Display Previous Quarter Sales in a Bar Chart as a default View

[praveen1108]

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

[praveen1108 · Accepted solution]

This helps!!

If(GetSelectedCount(Quarter)=0,

Sum({<QuarterNum={$(=Max({1<Year={$(=Max({1}Year))}>}QuarterNum-1))}>}MEASURE),

Sum(MEASURE))