Iam using MS analysis Services to build a cube on the Order manegement system, The formula for the total # of orders are the sum of DISTINCT COUNT function of order id's. I host it on the web using the pivot table.
There are around 10 product groups and a order can belong to multiple product groups, hence when I select all the product groups then I get the grand total summed up correctly, but when I try to filter to say 2 out of 10 then I get a VALUE! error. Error message being Cannot use aggregate function on DISTINCT COUNT