https://communities.sas.com/t5/SAS-Visual-Analytics/text-box-next-to-the-graph-with-last-wk-sales/m-p/769742#M15324 <P>This one comes close to what you're trying to do I suppose.</P> <P>I play with different date formats duplicating the original ddmmyy10. date variable.</P> <P>In order to make the difference vs. last week calculate correctly I filter the list table by Monday. this does no harm to the correct sum, The aggregated periodic measure has a apply filter option.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="a1.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/63958i8EA9438F97A0B934/image-size/large?v=v2&amp;px=999" role="button" title="a1.png" alt="a1.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="call_out.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/63956i486179A62376D226/image-size/large?v=v2&amp;px=999" role="button" title="call_out.png" alt="call_out.png" /></span></P> Wed, 22 Sep 2021 22:25:37 GMT acordes 2021-09-22T22:25:37Z https://communities.sas.com/t5/SAS-Visual-Analytics/text-box-next-to-the-graph-with-last-wk-sales/m-p/766421#M15258 <P>I have a request for difference in sales vs last wk and vs last wk previous year. This text box should be next to the graph and change with year filter but always show the difference vs last wk. How to calculate it?</P> <P>I was thinking about function max week -1, but how to do the rest? Pls advise a smart solution. It seems to be possible in Tableau.</P> <P>&nbsp;</P> <P>I have found a&nbsp;periodic operator parallel period in VA but is seems to work only in list table with weeks. Or maybe I could take the value from there and by using links get in the text box? But how to do that?</P> Tue, 07 Sep 2021 15:43:23 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/text-box-next-to-the-graph-with-last-wk-sales/m-p/766421#M15258 touwen_k 2021-09-07T15:43:23Z https://communities.sas.com/t5/SAS-Visual-Analytics/text-box-next-to-the-graph-with-last-wk-sales/m-p/769742#M15324 <P>This one comes close to what you're trying to do I suppose.</P> <P>I play with different date formats duplicating the original ddmmyy10. date variable.</P> <P>In order to make the difference vs. last week calculate correctly I filter the list table by Monday. this does no harm to the correct sum, The aggregated periodic measure has a apply filter option.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="a1.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/63958i8EA9438F97A0B934/image-size/large?v=v2&amp;px=999" role="button" title="a1.png" alt="a1.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="call_out.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/63956i486179A62376D226/image-size/large?v=v2&amp;px=999" role="button" title="call_out.png" alt="call_out.png" /></span></P> Wed, 22 Sep 2021 22:25:37 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/text-box-next-to-the-graph-with-last-wk-sales/m-p/769742#M15324 acordes 2021-09-22T22:25:37Z