18 Replies Latest reply: Sep 10, 2017 10:44 AM by Sunny Talwar RSS

    Aggr only work in specific dimension

    Amalesh Mondal

      Dear Expert,


      Here is my problem.


      I have an application where multiple dimension table are present such as.

      Product, Organisation, Customer, and fact table.


      Requirement is to create a measure, and that measure will be aggregated based on only Organization and Product.


      So i have created so far like below




      Its giving be the correct result while i have a table with product field with measure.


      Problem arise while i am adding any customer field its giving me incorrect numbers / %. Please note i can't aggregate on customer level.


      but while i select only one customer in filter its giving me correct number.



      Please help !! can we handle this in some way? !