Forum Discussion
ph
Helper I
Helper Itotal count with slicer
Hello,
I have following table
| DATE | Value |
| 01.10.2019 | A |
| 04.10.2019 | A |
| 04.10.2019 | B |
| 05.10.2019 | B |
| 05.10.2019 | B |
| 05.10.2019 | A |
When I set up slicer on the dates 04.10.2019-05.10.2019
I need to see following result
| Value | COUNT |
| A | 5 |
| B | 5 |
AND NOT
| Value | COUNT |
| A | 2 |
| B | 3 |
any idea how to do it? I tried, calcute(counta(value),date) and got only second result, that I don t want
thx
I solve it myself..
calcute(counta(value),ALLSELECTED())
1 Reply
phI solve it myself..
calcute(counta(value),ALLSELECTED())