Forum Discussion
Jlevring
Apr 08, 2022Copper Contributor
sales index in Pivot
I have a problem with a sales index in Pivot. I have tired the index solution, but it doesn't show the development in sales, but then most important value for that column.
I can calculate that but I would like the Pivot to do it automatically.
Any good advice?
Thanks
Jesper
Jlevring In the "Value filed Settings", select Show Values As, % Of and then Year as the base field and 2019 as the base item.
2 Replies
- Riny_van_EekelenPlatinum Contributor
Jlevring In the "Value filed Settings", select Show Values As, % Of and then Year as the base field and 2019 as the base item.
- JlevringCopper Contributor