count outside of group

• sparky-407434

  Right there with Babe

  Points: 731

  More actions

  November 24, 2014 at 3:32 am

  #145440

  Hi, I'm not sure if this is an Analysis Services query or a Reporting Services query. Hopefully someone can point me in the right direction.

  I have a multidimensional cube and a Reporting Services report. The report has a number of row groups, e.g. Department,Product_Type etc. and the measure is a count of Sales. I need to be able to indicate if the customer also has a sale outside of a particular group.

  For example for a customer with a sale in both the Hardware and Gardening Departments, when "Hardware" is drilled into to find the customer_id - it should be able to show that there is another sale in Gardening. It would not have to actually have "Gardening" it could have just an Order_Count for this Customer_id. So the Order_Count would need to be outside of the Department grouping.

  I'm not sure if I need to create a new Measure without joins to the Dimensions used in the row groups, or is there a way in Reporting Services to include data outside of the row group.

  Thanks in advance.

• sparky-407434

  Right there with Babe

  Points: 731

  More actions

  November 24, 2014 at 5:30 am

  #1760477

  Resolved - Added a new field in database with the count using Partition Over.