add countd of filtered values for each item in data set as a column in data set
I have attached a simple workbook.
On the dashboard, what calculation can I add against each value in visual Sheet1 to determine total row counts in Sheet2 pre-filtering?
Book1.twbx 8.7 KB
Since you did not attach workbook. I attach the solution with superstore sample. When you click a State, corresponding cities will be showed in the city sheet. You can see under Alabama, there are 8 cities, under Arizona, there are 13 cities, etc.
Hope it helps.
Book1.twbx 1.2 MB
Thank you for your replies.
I think what has compounded my issue is that there is a complex calculation which returns data for the second visual for which I will need take into account when creating a more detailed calculation rather than just COUNTD.
Thanks again for your input!