Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Dynamically change column value in a cross tab

Reply
Occasional Contributor s_j
Occasional Contributor
Posts: 6

Dynamically change column value in a cross tab

 

Hi Friends,

 

My question  is if I filter month field in the slider then my "targets"  field should be constant through out from Jan-Dec Month but "achv" field should change dynamically as per current selection.

Ex: If I select month field as Jan'16 to Apr'16 thenTarget=120 and Achv=25, Similarly If I select month field as feb'16-jun'16 then again target=120 and achv=50.

Here targer field is constant through out the period because it's fixed for the entire year but my achievement is changes month by month.

 

I am also attaching the screen shot for the same.

 

Regards,

Sumit

Post a Question
Discussion Stats
  • 0 replies
  • 103 views
  • 0 likes
  • 1 in conversation