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

       

      Sum(AGGR(SUM(FactValue),ProductID,Org_ID))

       

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