I want to show percent difference from one month to the next, but I want it on a new line below the sales dollars. How can I keep the sales dollars and show the percent difference on a new line?
I don't want to lose the sales numbers when I show the percent difference.
3 answers
Hi Yvonne,
Create a duplicate of Sales field and drag both sales and the duplicate on the row shelf and set the duplicate field as the percent difference using quick table calc.
See the attached image, here instead of duplicating the field, i first set the percent diff and then dragged sales again.
Hope this helps
