Forum Discussion
Helper IVSummarize the index
Hello,
I've created the following simple Matrix which displays chosen columns based on a slicer choice. Howvever it only works if the index column is included in the matrix. But by doing this unfortunately it is not summarising - do you know if there is a way to get it to summarise ?
Not Summarised
7 Replies
- amitchandak
Super User
richard_wylde , when you group by index, how will group field 1 which is the higher granularity ?
richard_wyldeHi amitchandak ,
The result I'd be looking for is below (the value of the Index field doesn't matter as I'd hide this in the visual )
Index FIELD1 FIELD2
3 D 10
3 C 10Do you know if this is possible ?
Hi richard_wylde ，
It's really unavailable to achieve what you need:
I can realize as below:
But once I remove index column,it will only show one value:
And columns are fixed values,it cant be changed dynamically.measures without context will be aggregated as one value,in your column col1 and col2,the duplicated values are in different rows ,so it's difficult to write a calculate column to modify the index value,and when you select col 1 or col2 with "Mea" columns,it will run into trouble.
Hope the above make sense.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Hi richard_wylde ,
It is hard to realize as you expect,as measure is an aggregated value,if you dont use another column to split it into detailed rows,it will return only one value.
So,I think your solution is a best one,and it's unavailable to get an aggregated value based on your result.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
