Calculated Condition on Pivot table

[Anonymous]

Hi,

I would like my pivot table to be hidden, until the user selects a date from a Listbox and a Hour from another Listbox.

Can anyone assist?  How do you refer to objects states as a calculated condition?

Thanks in advance.

Regards,

[marcus_sommer · Accepted solution]

Put an expression like the following into the calculation-condition from the pivot within the object-properties in tab general:

if(getselectedcount(Date) = 1 and getselectedcount(Hour) = 1, true(), false())

- Marcus

[Anonymous]

Thanks, worked perfectly !

[bvssudhakar]

Hi Marcus,

I have one requirement, here i attached one qvw file in that file

If i select for filter 1: Baby Clothes in Category Name, Aino Shoes from Product name, 2012 from Year and

for filter2:Baby Clothes in Category Name, Deuce Shirt from Product name, 2013 from Year

then i want out like this

2422	2/16/2012	Baby Clothes	Aino Shoes	Halle Köln	Bob Park	41
2422	2/16/2012	Baby Clothes	Deuce Shirt	Halle Köln	Bob Park	11
4665	1/21/2013	Baby Clothes	Aino Shoes	La Moda d'il Futuri	Ricardo Gucci	61
4665	1/21/2013	Baby Clothes	Deuce Shirt	La Moda d'il Futuri	Ricardo Gucci	12

But output is not showing like this, it is showing selections related 572 rows some thing

Give some suggestions to out from this situation

Thank you in advance

Sudhakar

[marcus_sommer]

You are using multiple alternate states and your objects seems not to be in these states which you think they are. I suggest to re-thing your whole approach because I have the impression that it is too complex and overused.

- Marcus