Forum Discussion
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 be highly appreciated
Hey!
That would be something like this:
CALCULATE( SUM( YourColumnToSum), ColumnwithText = "YourWord" )Let me know if that helps!
5 Replies
Hi there!
You can try:
Measure = IF( HASONEVALUE( YourCategory ), CurrentCalculation, Total RFS/Total NWB )Let me know if that helps!
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 )
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.
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?
Hey!
That would be something like this:
CALCULATE( SUM( YourColumnToSum), ColumnwithText = "YourWord" )Let me know if that helps!
