Table Total

[colintemlett]

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 be highly appreciated

[colintemlett]

Hi Pablo

Need some help on a formula...

What formula would i use if i wanted to total a column value if it includes a specific word in anothe column?

If there is a word in column X c that is CONT sum the total colum for only those rows that have that word in the colum X?

[PabloDeheza · Accepted solution]

Hey!

That would be something like this:

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

Let me know if that helps!

[PabloDeheza]

Hi there!

You can try:

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

Let me know if that helps!

[colintemlett]

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]

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.