Is it possible to sum only the no hide values?
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
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.
Please sign in to leave a comment.