Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can someone help me with logic for below:
I have Bar chart which should display default view of previous quarter sales but if i select the specific quarter it should display only selected quarter sales. my selection is Quarter in format Apr-Jun 2015 etc..
Some one Please help me with Previous Quarter Sales Logic and how we can display a default view of bar chart to previous and later to specific selected quarter sales.
Thanks for the help in advance.
Regards,
PK
This helps!!
If(GetSelectedCount(Quarter)=0,
Sum({<QuarterNum={$(=Max({1<Year={$(=Max({1}Year))}>}QuarterNum-1))}>}MEASURE),
Sum(MEASURE))
This helps!!
If(GetSelectedCount(Quarter)=0,
Sum({<QuarterNum={$(=Max({1<Year={$(=Max({1}Year))}>}QuarterNum-1))}>}MEASURE),
Sum(MEASURE))