Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a DB like so:
CALLING_MSISDN, CALL_DATE, WEEK, PREMIUM_RATE
1 ,07-05-2016, 18-2016, 3
1 ,08-05-2016, 18-2016 5
1 ,11-05-2016, 19-2016 10
2 ,18-05-2016, 20-2016 15
2 ,23-05-2016, 21-2016 5
......
I use a pivot table to show me the delta and delta% between the different weeks using this function:
IF ( RangeSum (Below(sum(PREMIUM_RATE)))<> 0, (sum(Total < CALLING_MSISDN, WEEK> PREMIUM_RATE) - RangeSum (Below(sum(PREMIUM_RATE))))/
sum(Total < CALLING_MSISDN, WEEK> PREMIUM_RATE)
, '')
I want to display the delta % on a graph (line chart). So that I will see the weeks on the buttom and the % change on the Y axis.
How can I do that?
Thank you