brackenrig
New Member
- Joined
- Jul 28, 2017
- Messages
- 1
I have a data set for annual budget planning - 50 clients with multiple line items per client (i.e. Account Management, Project Management, Licensing, Freight etc)
i'm comparing last year budget to this year's budget and want to show both the numeric delta and the percentage deltas for each line item. Numeric values are easy but can't figure out how to show the percentage differences.
For example under Client A, last year's budget was 1.0M and this year is 1.1M.
Need to show the numeric increase of 100K and the percentage increase of 10%
The pivot needs to show the same numeric and percentage items for each client or line item (based on how the pivot is set up).
Make sense? Any help?
i'm comparing last year budget to this year's budget and want to show both the numeric delta and the percentage deltas for each line item. Numeric values are easy but can't figure out how to show the percentage differences.
For example under Client A, last year's budget was 1.0M and this year is 1.1M.
Need to show the numeric increase of 100K and the percentage increase of 10%
The pivot needs to show the same numeric and percentage items for each client or line item (based on how the pivot is set up).
Make sense? Any help?
