Forum Discussion

mibu's avatar
mibu
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Numerous Subtotals Formula

Hey Everybody!   I have the following data: Type / Units A / 100 B / 200 C / 300   Is there a formula that will allow me to show the following in a Matrix: Type/Units A / 100 B / 200 C / ...
Need Help
mibu's avatar
mibu
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Hi v-xicai 

I am looking for a Measure that will allow me to create the following:

Sum of A+B

Sum of A+C...

THEN...  be able to pull them both into Row section of a single Matrix.

Matrix will automally Grand Total A+B+C.

Including other contributors to this thread:

Nathaniel_C 

MFelix 

Thanks Team!

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi mibu , Just paging mfelix for his viewpoint.

  • mibu's avatar
    mibu
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    Hi Nathaniel_C

    Ah...  very good, I am just working on MFelix  proposed solution.

    very best, mibu