Forum Discussion

hackfifi's avatar
hackfifi
Helper V
8 years ago
Solved

Drill Level Matrix - Calculation Query

  Is there a way to control the CALCULATION in Matrix based on Drill Level?   In my DATA table, i have column "Quantity".  When using the MATRIX Visual, the Column "Quantity" & "Hours" is Summed u...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi hackfifi,

     

    Here is the calculated field formula i wrote for Quantity

     

    =if(HASONEVALUE(Table3[Type]),SUM([Quantity]),BLANK())

    Hope this helps.

dilumd's avatar
dilumd
Impactful Individual
8 years ago

Hi,

 

you can switch off the sub total option under format tab, but unfortunately you can’t control it by column wise.

hackfifi's avatar
hackfifi
Helper V
8 years ago

Thanks dilumd -Maybe i need to think of another visual to represent the data. Cheers