Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
2 years ago
Solved

Selectively display Subtotal

AlexisOlson  parry2k How can I selectively display subtotal for a measure (with or without CalGrp) ; Currently I am doing this     PFA Sample   Thank you in advance
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    I'm not sure I fully understand what you want the output to be (a bunch of blank total lines?) but I would try ISINSCOPE instead of HASONEVALUE.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

This is a blind spot - if a parent category only has one child the HASONEVALUE is ineffective. 

 

Have you considered selectively disabling the row total for that category?

 

 

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
2 years ago

Thanks lbendlin  I don't think it would work the I way I want it.  I was hoping for a progrmatic way to achieve this if possible

 

//pseudocode

if(max(tbl[cat])=3 && issubtotal(tbl[_input])=true(), [_input],BLANK())