{"id":194,"date":"2011-11-17T17:48:48","date_gmt":"2011-11-17T15:48:48","guid":{"rendered":"http:\/\/www.flip-design.de\/?p=194"},"modified":"2011-11-27T17:56:17","modified_gmt":"2011-11-27T15:56:17","slug":"ssrs-berechnungen-innerhalb-eines-tablix-mit-der-vorherigen-zeile","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=194","title":{"rendered":"SSRS: Berechnungen innerhalb eines Tablix mit der vorherigen Zeile"},"content":{"rendered":"<p>Um innerhalb einer Tabelle (Tablix) mit der vorherigen Zeile zu rechnen, kann die Funktion Previous() genutzt werden. Diese liefert die Daten aus der vorherigen Zeile zur\u00fcck:<\/p>\n<pre escaped=\"true\" lang=\"vbnet\">=Fields!Umsatz.Value-Previous(Fields!Umsatz.Value)<\/pre>\n<p>Ergebnis:<br \/>\n<a href=\"http:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/TablixCalculate.png\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/TablixCalculate.png\" alt=\"\" title=\"TablixCalculate\" width=\"606\" height=\"81\" class=\"alignleft size-full wp-image-195\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/TablixCalculate.png 606w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/TablixCalculate-300x40.png 300w\" sizes=\"(max-width: 606px) 100vw, 606px\" \/><\/a><\/p>\n<p>Um nun jedoch diese Daten als Prozentwert f\u00fcr einen Indikator wiederverwenden zu k\u00f6nnen (Darstellung eines Trends), darf jedoch die Funktion Pervious() nicht mehr eingesetzt werden, da diese bereits eine Aggregat-Funktion beinhaltet. Daf\u00fcr ist es dann notwendig, dass die Daten pro Zeile erstmal zwischengespeichert werden. Das kann \u00fcber eigenen Code innerhalb der RDL erreicht werden:<br \/>\n<a href=\"http:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/TablixRDLWithCode.png\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/TablixRDLWithCode.png\" alt=\"\" title=\"TablixRDLWithCode\" width=\"788\" height=\"511\" class=\"alignleft size-full wp-image-196\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/TablixRDLWithCode.png 788w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/TablixRDLWithCode-300x194.png 300w\" sizes=\"(max-width: 788px) 100vw, 788px\" \/><\/a><\/p>\n<p>Nun kann einerseits in der Tabelle die prozentuale Ver\u00e4nderung dargestellt werden<\/p>\n<pre escaped=\"true\" lang=\"vbnet\">=code.ZeigeProzentualeVeraenderung(Fields!Umsatz.Value, Previous(Fields!Umsatz.Value))<\/pre>\n<p>und diese Daten k\u00f6nnen nun in einem Indikator verwendet werden:<br \/>\n<a href=\"http:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/tablixRDLCodeFunctionForIndicator.png\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/tablixRDLCodeFunctionForIndicator.png\" alt=\"\" title=\"tablixRDLCodeFunctionForIndicator\" width=\"1001\" height=\"654\" class=\"alignleft size-full wp-image-197\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/tablixRDLCodeFunctionForIndicator.png 1001w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/tablixRDLCodeFunctionForIndicator-300x196.png 300w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/a><\/p>\n<p>Ergebnis:<br \/>\n<a href=\"http:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/tablixResult.png\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/tablixResult.png\" alt=\"\" title=\"tablixResult\" width=\"763\" height=\"323\" class=\"alignleft size-full wp-image-198\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/tablixResult.png 763w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2011\/11\/tablixResult-300x126.png 300w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Um innerhalb einer Tabelle (Tablix) mit der vorherigen Zeile zu rechnen, kann die Funktion Previous() genutzt werden. Diese liefert die Daten aus der vorherigen Zeile zur\u00fcck: =Fields!Umsatz.Value-Previous(Fields!Umsatz.Value) Ergebnis: Um nun jedoch diese Daten als Prozentwert f\u00fcr einen Indikator wiederverwenden zu &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=194\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[25,24,3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/194"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=194"}],"version-history":[{"count":10,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/194\/revisions"}],"predecessor-version":[{"id":218,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/194\/revisions\/218"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}