I am trying to use a pivot table (as I need to use slicers with report connections) to display totals combining data from multiple table columns.
Sample attached with example pivot table not displaying correct count/sum.
I am trying to use a pivot table (as I need to use slicers with report connections) to display totals combining data from multiple table columns.
Sample attached with example pivot table not displaying correct count/sum.
1. Use the following Power Query (Get & Transform) advanced editor code to convert Table1 into a table of records as displayed in columns A:C on the Table1 sheet:2. Use the new table to produce a pivot table.Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks