3 Replies Latest reply: Nov 18, 2011 3:15 AM by upendrar RSS

    need help in a pivot table??

    Sushil Kumar

      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