topic Dimension as a measure in App Development

Dimension as a measure

Krish — Fri, 26 Apr 2024 10:42:32 GMT

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

Re: Dimension as a measure

mpc — Fri, 26 Apr 2024 11:52:42 GMT

Hi,

You can use the Aggr function to use an expression as a dimension.
For instance: =Aggr(Count(ID),Dim1)

Kind regards

Re: Dimension as a measure

Krish — Fri, 26 Apr 2024 12:23:35 GMT

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)

Re: Dimension as a measure

mpc — Fri, 26 Apr 2024 12:25:12 GMT

Ok, then aggr(count(ID),Dim1,ID,Name,Country), caveat, it could greatly impact performances

Re: Dimension as a measure

Krish — Fri, 26 Apr 2024 12:47:06 GMT

@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.

Re: Dimension as a measure

delmak2000 — Thu, 02 May 2024 08:50:59 GMT

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