Show all irrespective of selections

[viveksingh]

HI all,

i have data like

Dept	Name	Sal	Date
FIN	KL	250	20/7/2018
HR	DEF	80	30/8/2018
IT	ABC	100	1/9/2018
IT	HG	180	2/9/2018

‌ if I select a date it should show data for that date and for rest, it should show as zero.

ex: selected 1/9/2018

below is expected output

Dept	Name	sal
FIN	KL	0
HR	DEF	0
IT	ABC	100
IT	HG	0

[tresesco · Accepted solution]

Say you are using expression Sum(sal) for sal calculation. Re-write it like:

=Sum(val)*Avg({1} 1)

And, uncheck 'Supress zero values' in presentation tab.

[Anonymous]

Hi,

Perhaps look at: Set Analysis - Ignore all selections except certain field

[viveksingh]

‌perfect thanks Tresesco.

I Tried with Avg(1). But no luck.

Thank you