Hide data on Dimension

[#1]

Dear all,

i have a problem and I don't know how to solve.

Take this example

NUMBER

DATA

VALUES

Imagine that we have data on table, but some values on field data are null.

Now, imagine that we create a pivot table with "NUMBER" as dimension and "SUM(VALUES)" as Expresion.

I want to hide al Number with data field empty without set "DATA" as Dimension.

It's possible.

Best regards.

[#2]

Solved with a Calc dimension

if (isnull(DATA),Null(),NUMBER)

And check hide null data.

If you know best way, please let me know,

[#3]

use set analysis

something like sum( {$<data={"*"}>} values )

[#4]

It will be valid on that example.

But if I have more expressions, i have to put a set analysis on every expression, and I want to create pivot table without set analysis function.

I will try to check how many memory process needs.

[#5]

in my experience is it better solution than IF statements.

but, try with your data and let me know