marcobombo
Contributor
2016-08-09
06:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pivot table: Percentage difference between columns on the same dimension
Hi,
I have this problem. I want to make the percentage difference between the columns in a pivot table on the same dimension (Year).
It is possible?
I attache the example.
Thanks
1,291 Views
1 Solution
Accepted Solutions
Clever_Anjos
Employee
2016-08-09
07:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1-Before(sum(Value))/sum(Value) returns the variation
4 Replies
Clever_Anjos
Employee
2016-08-09
07:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Before(sum(Value)) will bring you the value of left column
Clever_Anjos
Employee
2016-08-09
07:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1-Before(sum(Value))/sum(Value) returns the variation
sunny_talwar
MVP
2016-08-09
07:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This?
Probably too many hard-corded value and can somehow be automated
1,184 Views
marcobombo
Contributor
2016-08-09
10:09 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The result is ok.
1,184 Views