need help in a pivot table??

[sushil353]

Hi all ,

In my dashboard i have a pivot table in which some calculations are done over some operations and location.

i have OPERATION and LOCATION in separate field as well....

i want to show results in pivot table for all operations and for all locations...irrespective to the selection made from fields..

but whenever i select any operation or location from the separate field the pivot table got filtered according to the selection (normal behaviour of QV)

the sample application is attached....

Please help me to solve this problem..

Thanks

Sushil

[Anonymous]

Hi,

did u try   sum(  {1} fail)?

[sushil353]

Thanks Buddy

[#4]

Hi,

You have 2 options to do that

1) detached tha chart (properties--general tick on detached)

2)try this sum({1}fail) and sum({1}process)

Hope this will help you.

Thanks & Regards

Upendra