Here is a simple example data set:CustName Location Cafe Restaurant Takeaway SalesDollars------------------------------------------------------------------The Views Ballarat Yes Yes No 250Fast Eddies Melbourne Yes No Yes 500Olive Grove Ballarat Yes Yes No 1000
Can anyone make a cube that gives these results??View1 - Customer Type by SalesCafe $1750Restaurant $1250Takeaway $500-----------------Total $1750 View 2 - Customer Location by SalesBallarat $1250Melbourne $500-----------------Total $1750
Edited by - tim on 12/12/2001 18:59:31
children of multiple members at same level
Posted - 2001-12-12 : 17:32:04
