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?)
