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 did per your guidance and get the following result:

What I need however is for the Matrix to read:

Cumulative total / 3600

I need it to show as a row, not a column in the Matrix.

Thoughts?

Thanks!

mibu

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