7 Replies Latest reply: Oct 3, 2013 6:34 AM by Nizam HM RSS

    hiding/showing column for analysis at different level

      Hi,

       

      I'm going to explain my problem and my solution and I'm kindly ask you to give me a hand  on how to implement it because I'm very new on QV...so I need your help to do this.

      I have a straight table and I need to analyze the sales at different level: Country or City.
      Initially, I have displayed the Sales for Country and City and I'd like to have a button called 'Hide City'. In this way, by pressing it, the City column will disappeared and the Sales will be grouped by Country. Then I'll do the contrary operation and I'll expand the City Colum. Please, look at the enclosed file to understand better my request.


      Thanks

      Cristina