Forum Discussion
Matrix without aggregation
Hi GoingIncognito ,
Using matrix the values make the aggregations as you refers, in your case all the data that you don't want to have as aggregated value you should place on the rows of the matrix and then expand the matrix to the lowest level.
So no way of bybassing this? Like no amount of writing measures that use summarize will resolve this?
Hi GoingIncognito ,
Not really understanding your question, from the columns below what are the ones you don't want aggregated:
Date
Name of the instrument
ISIN code
Currency
Amount bought
Price per share
Assuming that amount bought would have aggregation the others not, so if you place everything in rows and amounth bought in values should have values you need.
Hi there - did you find an easy way to accomplish this one? I'm stuck too and a bit baffled why they couldnt just dont include Don't Summarize on the Value settings so it only displays on the last Row. Thanks for any info
Sorry, it has been such a long time I really don't recall. I think I used a
if( hasonevalue(table[field]), measure, blank()/another measure )
