Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobi
Partner - Contributor II

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.

 

 

Labels (1)
1 Reply
dplr-rn
Partner - Master III

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