Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i want to calculate QoQ Variance in Pivot Table .
if no year is selected it should show Current year(2017) data .
if no year selected its showing correct values for 2017 Q1 But remaining quarters its showing blank.
i want to display QoQ variance for remaining quarters as well
How to show QoQ Variance for Q2,Q3,Q4.
please find the attached screen shot results for 2017 Q2,Q3,Q4
Formula:Q2 Amount-Q1Amount/Q1 Amount
Thanks,
Joshi
Try this
Only({<Year = {"$(=Max(Year))"}>} Aggr(Sum({<Year = {"$(=Max(Year))"}>}Amount)
/Above(Sum({<Year, Quarter, YearQuarter>}Amount))-1, Division, (YearQuarter, (Text))))
Try this
Only({<Year = {"$(=Max(Year))"}>} Aggr(Sum({<Year = {"$(=Max(Year))"}>}Amount)
/Above(Sum({<Year, Quarter, YearQuarter>}Amount))-1, Division, (YearQuarter, (Text))))
Hi Sunny ,
Thanks for your valuable time .
working in sample but not in my original data...
Thanks,
Joshi
What's the difference between the sample and your original file? I won't know until I see it...
Please can someone explain this complex expression