show dimension value if set analysis is empty

[nboccassini]

Hi all,

I have a table like this:

LOCATION	type	value
a	1	100

In a pivot table (with location as dimension) I use the expression sum({<type={2}>}value) but the result is an empty table.

How show a result in pivot like

LOCATION	sum({<type={2}>}value)
a	-

Regards

[Taoufiq_Zarra]

@nboccassinican you elaborate

type={2} assumes that you already have row with type=2 ?

[nboccassini]

Yes, 

the fact is over 3 millions of row and I need ti calc the kpi sum({<type={2}>}value).

The problem is that I want to show '-' if the kpi is null (but showing only the selected location, so I can't use "show all value" properties)

[Kushal_Chawda]

@nboccassini  you can try below expression in pivot table

=sum({<Type={2}>}Value) + sum({1}0)

Note: Uncheck "Suppress zero-value" option from presentation tab of chart properties. You won't be able to show "-" but it will be "0" because  you are using Sum function. If you still want to show is as "-" then try below

=if(sum({<Type={2}>}Value) + sum({1}0) =0, '-', sum({<Type={2}>}Value) + sum({1}0))