Add Calculated Custom Rows in Matrix Visual.

[souvik900766]

Hi !
My Data Link:-https://www.dropbox.com/s/po1bu897ml8h800/Custom%20Calculated%20Rows.pbix?dl=0
I want to add Calculated Custom Rows in Matrix Visual.
This is my Matrix Visual and at the end of Brands for both category I want to add two custom rows.
One will have Core Brands(That will comprise of few selected Brands)
The Other will have Others(e.g. 100000-sum(all brands).

How I want it to be:-
(This brands are selected randomly for e.g purpose)

Thanks in advance.

[DataInsights · Accepted solution]

@souvik900766,

You can create a grouping table like the one below, and add the Grouping column to the matrix.

The link in your post no longer works.