Forum Discussion

niel_orvyn1's avatar
niel_orvyn1
Helper III
5 years ago

Matrix with values from different rows

Dear Community,


I'm trying to create a visual to show a Gross Profit Analysis using Currency Value/item volume. In this case, it will be currency per liter.

I am currently achieving this by doing multiple measures and displaying each value manually with a card (Sales; Cost of Sales is text boxes).

See the below example:



 

Below is an example of how the table looks and the measures currently used to get the above value:

 

You will notice the AccountType column item descriptions are different for "1. Volume", however below rows they will only have a prefix, for example, Sales: Diesel; COS Diesel; Adjustment: Diesel.

 

Is there any other way to do this, maybe with a switch with multiple conditions and measure to display this in a table or matrix? 

 

Look forward to your reply. 

 

Best Regards,

Niel

2 Replies