Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm new to data analysis. I'm using ClikSense Desktop and I need to show a column in a pivot table that shows percentage change from one column to the next:
Essentially my pivot looks like this:
Avg([Current Total Dollar Sales]) Avg([Previous Total Dollar Sales]) Avg([Current Total Dollar Sales])- Avg([Previ ous Total Dollar Sales])
Deluxe $472,222 $400,000 $72,222
Economy $432,987 $400,000 $32,987
Flavored Deluxe $423,234 $400,000 $23,234
etc. etc. etc.
What would my expression be to change the last column to % difference rather than value difference? I've also attached a screen shot of this section of my app.
Any help would be so greatly appreciated.
Try something like
=Num( (Avg([Current Total Dollar Sales]) / Avg([Previous Total Dollar Total Sales] -1),'#0.00%','.',',')