1. TARGIT Community
  2. Community
  3. User Tips and Tricks
Knowledge Base

Is it possible to sum only the no hide values?

Tomás Masiá ·

Hello good morning,

I need help with the sum of the visible cells of a calculation. I need to know how to make the sum of the visible cells with the option (hide value) not (hide member).

I have tried the following calculation sum(0, all(v), 0), but it only works with hide members values.

It is possible to make a summation of only the no hide values.

Excuse me for my bad English...

0

Comments

1 comment
Sort by DateVotes
  • Marlene Knaup

    Hi Tomás, unfortunately the v does not work at this point. I only know this workaround with a calculated measure as helper column. 

     

     

     A total can now be displayed, but a count unfortunately does not work. But maybe it helps for your case. 

    0
Please sign in to leave a comment.