Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Subtract Percentages from the same table, different graphs, different filters.

Dear

I have two charts (matrix), both contain the same fields/measures, the variant is the FILTER of each chart.

The first shows the Distribution of Sales by Brand in the TOTAL of Zones and the percentage of participation of each one:

The second graph (also a matrix) shows the same values with a Zone filter applied:

What I'm looking to realize is a DIFFERENCE between the Percentages of representation in each Brand.

In other words, Brand 1, in ALL AREAS, represents 0.85% of Sales:

However, this same mark, in ZONE 2, increases to 9.62%:

What I need, and at first it seemed simple to me, but I didn't manage to do it, is to get in another graph, in another table or wherever, the percentage difference, whether it is greater or smaller.

I mean:

Mark 1 in ZONE 2 has an increase of n% over the % of ALL ZONES.

I hope you understand. Garcias!