Forum Discussion
"Analyze in excel" button
When we use the "Analyze in excel" button then users cannot make a pivot table with count, it does not allow them to drop any non-summed column into the value field, the pivot function will be used a...
Hi Anonymous
Yes this is working as expected. You can only put measures into the values quadrant of a Pivot Table. Implicit measures (measures created in visualisations) don't count. You'll need to create measures in your Datamodel for users to work with in Analyse in Excel.
Hope this helps
Stuart
Burningsuit
Resident Rockstar
Resident RockstarHi Anonymous
Yes this is working as expected. You can only put measures into the values quadrant of a Pivot Table. Implicit measures (measures created in visualisations) don't count. You'll need to create measures in your Datamodel for users to work with in Analyse in Excel.
Hope this helps
Stuart