Forum Discussion

shade206's avatar
shade206
Brass Contributor
Nov 19, 2020

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 ...
BI & Data Analysis
excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Nov 20, 2020

shade206 

Just for the record, the problem as posed can be solved with a single Dynamic Array formula

 

= LET(
  reason, SORT(UNIQUE(Data[Call Reason])),
  count,  COUNTIFS(
     Data[Call Reason], reason,
     Data[User ID], User),
  IF({1,0}, reason, count) )

 

 

 

Resources