Forum Discussion
Create a simple dynamic tally chart via dropdown list WITHOUT a Pivot Table
I have this Data set on "Sheet 1": User ID Call Reason Product ID Date Created 165 Billing 1229509 1/16/2020 165 Billing 1644846 1/29/2020 165 Billing 1569706 1/30/2020 ...
mtarler Its a part of an entire dashboard, so I need to be able to do it without it being a pivot table.
In general PivotTable, more exactly cube formulas, also could work. You may create PivotTable adding data to data model, based on it add cube formulas like
Formulas
in H2:
=CUBESET("ThisWorkbookDataModel", "[Range].[Call Reason].children", "Call Reason")
in H3:
=IFNA(CUBERANKEDMEMBER("ThisWorkbookDataModel",$H$2,ROW($A$1:$A$6)),"")
in I3:
=CUBEVALUE("ThisWorkbookDataModel",
"[Measures].[Count of Call Reason]",
"[Range].[Call Reason].&[" & $H3 & "]",
"[Range].[User ID].&["&$C$3&"]"
)
and drag it down
PivotTable itself could be removed from the sheet.