Matrix Subtract Subtotals for the Grandtotal

[Hijau]

Hi Community,

I'm trying to subtract the subtotals in my matrix so my grandtotal shows the correct value:

I.E. the grandtotal has to show 59.736,97; 101.921,30; etc. 

Help would be greatly appreciated! 🙂 

Thanks in advance and cheers,

Dexter

[v-yuta-msft]

Hi Hijau ,

I recommend you yo use a table visual instead, create a calculate column and use DAX formula like this:

Grandtotal =
CALCULATE (
    SUM ( table[value] ),
    FILTER (
        table,
        table[subcategorie] = "Uitgaven"
            && table[date] = EARLIER ( table[date] )
    )
)
    - CALCULATE (
        SUM ( table[value] ),
        FILTER (
            table,
            table[subcategorie] = "Omzet"
                && table[date] = EARLIER ( table[date] )
        )
    )

Regards,

Jimmy Tao

[Hijau]

Hi Jimmy!

Thanks for your reply :). I can't make it a table though since I would lose my drill options and those are important for the P&L I'm trying to make.. 

Best regards,

Dexter 

[Hijau · Accepted solution]

For anyone wondering, I figured it out by using the next formula:

Actueel W&V =
VAR Omzet = CALCULATE (SUM ('Financiële Data'[Bedrag]); FILTER('Financiële Categorieën';'Financiële Categorieën'[Subsubcategorie] = "Omzet"))

VAR Kosten = CALCULATE (SUM('Financiële Data'[Bedrag]); FILTER('Financiële Categorieën';'Financiële Categorieën'[Subsubcategorie] = "Kosten"))

RETURN
(Omzet - Kosten)

Cheers!