Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a Bar Graph which shows top 4 sales of previous Quarter (Q1 2015) by default and if i select a specific quarter it will display the respective values which works like a champ.
Now i need another trend chart below this Top 4 Sales Bar graph which should display a Trend of the sales for current and Previous Quarter Sales all the time.
Lets say if iam in Q2 2015 my Bar graph will show top 4 sales for Q1 2015 and my new trend chart should have both Q1 2015 and Q2 2015.If i select Q1 2014 then trend should show Q1 2014 and Q4 2013 (incase if there is no data for Q4 2013 it should dsiplay 0)
Some one please help me,i need this on very urgent basis.
I Appreciate for the help.
Regards,
PK
If(GetSelectedCount(Quarter)=1,
Sum({<Quarter=, QuarterNo={">=$(=Concat(DISTINCT QuarterNo)-2)<=$(=Concat(DISTINCT QuarterNo))"}>} Measure),
Sum({<QuarterNo={">=$(=Max(QuarterNo)-2)<=$(=Max(QuarterNo))"}>} Measure)
)
If(GetSelectedCount(Quarter)=1,
Sum({<Quarter=, QuarterNo={">=$(=Concat(DISTINCT QuarterNo)-2)<=$(=Concat(DISTINCT QuarterNo))"}>} Measure),
Sum({<QuarterNo={">=$(=Max(QuarterNo)-2)<=$(=Max(QuarterNo))"}>} Measure)
)