Calculation Between Columns

[cvarvar]

Hi all,

I have an issue on Matrix Table. I want to create an new Matrix table with dividations beetween columns. I made them with New Column, but my issue is that the Category summarize the column results and it is wrong. Attached you will find a sample of my data on the matrix.

So an example: 

For April, SEG "A":

- aa:

           - AAA: 401/1163 = 0.34

           - BBB: 762/1163 = 0.66

- bb:

           - AAA: 40/113 = 0.35

           - BBB: 73/113 = 0.65

So Total for AAA must be 441/1276 = 0.35, not (401/1163 = ) 0.34 + (40/113 = ) 0.35 = 0.64  and Total must be 0.48 = 1276/2627 not the Sum of AAA (SEG "A") + BBB (SEG "A") 

Thank you,

cvarvar

[Anonymous]

Hi @cvarvar ,

If the [customers] is a column, please use SUM([customers]) instead.

If it doesn't work, please share some sample data in table format.

Best Regards,

Jay

[amitchandak]

@cvarvar , assume the value of aa and bb is sub Seg , then create a measure like

divide([measure], calculate([measure], removefilters(Table, Table[Sub SEG])))

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37

[cvarvar]

Thank you for your answer.

There is an error here:

The field CUSTOMERS is numeric filed and it came from the base DB that is aggregated (CUSTOMERS = SUM(Record_Count))

Thank you.