7 Replies Latest reply: Mar 24, 2014 8:55 AM by Mads Berg Hansen RSS

    Top Level Data in a drill-down group

    johnlumley

      Hi, sorry if this seems a really basic question but I can't find the answer anywhere on the forums.

      I've set up a drill-down group along the lines Company>State>Store>Product. I would like the initial view to be total sales for the company but I can't get it to display at that level, the highest I can see is total sales by State. The rest of the drill works fine and I can click into a state and get total sales by store and then click into a store and get sales by product.

      It does work if I make it a cyclical group rather than drill-down but that takes away some of the fantastic functionality of the product and may not be quite as intuitive for the users.

      My data is set up as follows;

       

      Company

      State

      Store

      Product

      Sales

      UoL

      X

      A

      Hat

      988

      UoL

      X

      A

      Coat

      863

      UoL

      X

      A

      Shoes

      909

      UoL

      X

      B

      Hat

      656

      UoL

      X

      B

      Coat

      766

      UoL

      X

      B

      Shoes

      609

      UoL

      X

      B

      Socks

      105

      UoL

      Y

      C

      Hat

      956

      UoL

      Y

      C

      Coat

      517

      UoL

      Y

      D

      Hat

      653

      UoL

      Y

      D

      Coat

      863

      UoL

      Y

      D

      Shoes

      196



      Any help would be greatly appreciated

       

      Thanks

       

      John