Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating a pivot table where I have a measure which gives a count of ID. I need to to make it a dimension and collapse it so that it shows the count and upon clicking the expand option, I have to see new set of dimensions which will give the data for the count.
Something like this
Dim1 | count | |||
ABC | 200 | ID | Name | Country |
1 | aa | A | ||
2 | ab | B | ||
3 | bc | N |
Hi,
You can use the Aggr function to use an expression as a dimension.
For instance: =Aggr(Count(ID),Dim1)
Kind regards
Thanks for the response @mpc , but I tried using aggr(count(ID),Dim1) it shows blank for the ID,Name and Country fields. It works only when a value is selected for ID.
Also, my example has Valuelist as dimension (DIM1 is a valuelist)
Ok, then aggr(count(ID),Dim1,ID,Name,Country), caveat, it could greatly impact performances
@mpc ,
Please find the attached sample. My requirement is to see the 5 ID's displayed for Feb-2024 and 3 for Jan-2024. The ID values as rows.
Just add the column ID to the dimension and you should be fine. Except if you mean to achieve something else. I also recreated the output using your app sample. I hope it helps