7 Replies Latest reply: Aug 30, 2012 10:54 AM by whiteline _ RSS

    Double variable data in a set analysis expr

    Anna Perini

      Hi, I'm trying to solve a problem. I've a report for salesmanager and my customer is asking me to see in a table as default a total amount of sales for 'black hats', and ask two switch fields where he can select all Type (to sum also shoes and gloves) and another independent switch where select all Colours. When he deletes his selection he wants to be back to his default report for "black hats".

       

      TableA:

      LOAD * INLINE [

      Product, Type, Colour    Amount

      ProdA, Hat ,black, 100

      ProdB, Hat, black, 200

      ProdC, Hat, black, 200

      ProdD, Hat, white, 50

      ProdE, Hat, black, 200

      ProdF, Shoes, black,  300

      ProdG, Gloves, pink,  70

      ];

       

      LOAD * INLINE [

      Switch Type

      Yes

      ];

       

       

      LOAD * INLINE [

      Switch Colour

      Yes

      ];

       

      Thank you in advance!