
Partner - Contributor II
2019-11-06
09:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Change KPI in pivot table
Hi. Anyone who know if it is possible to exchange KPI in your pivottable.
Lets say you have 3 different columns:
Net sales 2019, Net sales 2018, Dev. 2019 Vs 2018 Net sales.
And you as a user just want to look on Cost 2019, cost 2018, dev. cost instead. Is there any way for this? And then I mean so that just net sales are visible first. And then you can change net sales to cost like you do with alternative measures in a chart.
- Tags:
- pivot tables
592 Views
1 Reply

Partner - Master III
2019-11-06
10:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use 'Show Column If' to hide/show appropriate columns.
e.g. use a button from dashboard bundle to set a variable. which controls the show and hide columns
e.g. use a button from dashboard bundle to set a variable. which controls the show and hide columns
