1 Reply Latest reply: Mar 22, 2013 12:40 PM by Ionut Cosconea RSS

    Repeated Value in Dimension

      Hi All,

       

      I could do with some help with my dimensions...

       

      I have a table showing total sales for departments in one of our stores, but I need to be able to show a total of the entire fashion floor for example, as well as a total of only some of the sections within that floor.

       

      My dimension looks like this at the moment:

       

       

      if (  AND DWH_ITEM_SUB_GROUP > 0

      AND (DWH_ITEM_SUB_GROUP=62

      OR DWH_ITEM_SUB_GROUP=60

      OR DWH_ITEM_SUB_GROUP=45

      OR DWH_ITEM_SUB_GROUP=43)

        ,'OWN BOUGHT FASHIONS', 

      if ( AND DWH_ITEM_SUB_GROUP > 0

      AND (DWH_ITEM_PRODUCT_GROUP_NO=528

      OR DWH_ITEM_PRODUCT_GROUP_NO=529

      OR DWH_ITEM_SUB_GROUP=62

      OR DWH_ITEM_SUB_GROUP=60

      OR DWH_ITEM_SUB_GROUP=51

      OR DWH_ITEM_SUB_GROUP=45

      OR DWH_ITEM_SUB_GROUP=43)

        ,'TOTAL FASHION FLOOR'))

       

      However, at the moment the results in the first row (own bought fashions) show the total of SUB-GROUPs 62,60,45,and 43 in 1 row, while the next row (total fashion floor)shows only the total of SUB-GROUP 43 and PRODUCT_GROUPs 528 and 529.

       

      Is there any way that I can get 'Total fashion Floor' to include the sub_groups which are repeated?

       

      The table contains other similar rows which all work fine, so I can't do a simple total at the bottom (unless there is a way to show a subtotal on just these 2 lines?)

       

      Thanks,

       

      Matthew