find difference in Pivot table

[Anonymous]

Hi guys,

I have a pivot table

I want to calculate difference between the same tag from previous period.

Other words: Check pricing Sep 2013 31%-Check pricing Aug 2013 27% = dif 4% and so on.

When I use above or below, it calculates for Sep 2013  31%-3%=28%; 3%-48%=-45% and so on in one current month.

But I'd like compare the same but with previous period.

Please see the attached file.

Thanks,

[swuehl]

Your idea using chart inter record functions is good, you just need to add advanced aggregation to tell QV the correct dimension order.

Check attached.

[MayilVahanan]

Hi

Try like this

Alt(aggr(

Count({<[qID_2_Primary purpose of visit]={'Learn about services','Check pricing','Purchase Vonage services','Find promotion info','Buy Vonage services','Other'}>}POV)/Count(TOTAL <MYear> POV)

-

above(

Count({<[qID_2_Primary purpose of visit]={'Learn about services','Check pricing','Purchase Vonage services','Find promotion info','Buy Vonage services','Other'}>}POV)/Count(TOTAL <MYear> POV)

)

,POV,MYear),0)

[Anonymous]

Thanks for suggestion

My original expression is bigger.

It works, when I switch dimensions (instead of Above, I use before)

I can't switch dimensions in my chart.

Please see my file.

[Anonymous]

Thanks for suggestion

My original expression is bigger.

It works, when I switch dimensions (instead of Above, I use before)

I can't switch dimensions in my chart.

Please see my file.

[swuehl · Accepted solution]

Why not? Please check attached

[Anonymous]

Thanks.  You're awesome