Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
did u try sum( {1} fail)?
Thanks Buddy
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