jasonjason
New Member
- Joined
- Sep 7, 2016
- Messages
- 2
Hi All,
I am building a pivot table using power pivot.
In the power pivot data model, i have created various 3-4 measures.
My question is when i create a pivot table normally we drag measures into pivot table value feild.
It could sum of sales, average age of salesperson, number of sales per person etc
Instead of me dragging these measures in value feild can i have a button where in, when i choose the correspoding value in button, it pulls only the requried measure
Justification: The reason i am doing this is because i am building a dashboard and instead of creating multiple pivots, i need to be able to create a single pivot which has capability to change valiue feild automatically based on button click.
I want it to be a easier experience for the user.
I am building a pivot table using power pivot.
In the power pivot data model, i have created various 3-4 measures.
My question is when i create a pivot table normally we drag measures into pivot table value feild.
It could sum of sales, average age of salesperson, number of sales per person etc
Instead of me dragging these measures in value feild can i have a button where in, when i choose the correspoding value in button, it pulls only the requried measure
Justification: The reason i am doing this is because i am building a dashboard and instead of creating multiple pivots, i need to be able to create a single pivot which has capability to change valiue feild automatically based on button click.
I want it to be a easier experience for the user.
