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.let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"How did you find out about our project", type text}, {"How did you find out about our project 2", type text}, {"How did you find out about our project 3", type text}, {"How did you find out about our project 4", type text}, {"Response ID", Int64.Type}}), #"Reordered Columns" = Table.ReorderColumns(#"Changed Type",{"Response ID", "How did you find out about our project", "How did you find out about our project 2", "How did you find out about our project 3", "How did you find out about our project 4"}), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Reordered Columns", {"Response ID"}, "Attribute", "Value"), #"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Question"}, {"Value", "Answer"}}) in #"Renamed Columns"
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