Forum Discussion

colintemlett's avatar
colintemlett
Regular Visitor
3 years ago
Solved

Table Total

Hi   Is it possible to do a specific callcualtion for a row/colum total Per below i need the total NBCP value to being the Total RFS/Total NWB = 435 and not the sum of that column??   Help will ...
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    Hey!

    That would be something like this:

    CALCULATE(
	SUM( YourColumnToSum),
	ColumnwithText = "YourWord"
)

    Let me know if that helps!

PabloDeheza's avatar
PabloDeheza
Solution Sage
3 years ago

Hi there!

You can try:

Measure = 
IF(
    HASONEVALUE( YourCategory ),
    CurrentCalculation,
    Total RFS/Total NWB
)

Let me know if that helps!

colintemlett's avatar
colintemlett
Regular Visitor
3 years ago

Hi

 

Sorry a little confused with the below..what would I add to category…and I cant seem to add in a formula at te end..do i need to do a measure for the total RFS and total NWB

Measure = IF( HASONEVALUE( YourCategory ), [NBCP per RFS] , Total RFS/Total NWB )

 

 

 

 

  • PabloDeheza's avatar
    PabloDeheza
    Solution Sage
    3 years ago

    Hi!

    CAB would be you "Category", I assume CAB stands for "Cabinet" which you already added, so it looks good. 

    For Total RFS/Total NWB you need to either create a measure that returns the value you want in the total, or apply the calulation right there.