Forum Discussion

Portrek's avatar
Portrek
Resolver III
5 years ago
Solved

Others line - group

Hi everyone. Consider a table that among other information has a column related to item, and among these items there are some classifications when the item is enhanced with two certain plants, and...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Portrek ,

     

    You need to use BLANK() instead of ISBLANK(). The calculated column here is better than the measure, I would recommend the calculated column.

    Calculated column is

    Column = IF([PART]=BLANK(),"OTHERS",[PART])

     

    Both the year column and the calculated column select don't summarize, and the ITEM column selects count.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Portrek's avatar
Portrek
Resolver III
5 years ago

Hi Tom. Thanks for your anwser, but it's not that..

 

I need to make a measure that within the row context sort the existing values ​​and add a row with the sums of the items that don't have any additional trappings as if they were the remaining items..

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Portrek ,

 

You need to use BLANK() instead of ISBLANK(). The calculated column here is better than the measure, I would recommend the calculated column.

Calculated column is

Column = IF([PART]=BLANK(),"OTHERS",[PART])

 

Both the year column and the calculated column select don't summarize, and the ITEM column selects count.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.