5 Replies Latest reply on Feb 24, 2016 7:47 AM by pooja.gandhi

    Controlling Aggregation of data

    Mahadev Somashekhar

      Dear Sir/Ma'am,

      Could you please advise on how to control the Aggregation of data

       

      Example:

       

      Excel Sheet 1

       

      Month                    User                    Product_QTY

      Jan 2016               A                            1

      Jan 2016               B                            1

      Feb 2016               A                            2

      Feb 2016               B                            1

       

       

      Excel Sheet 2

       

       

      User           Dept

      A                    D1

      A                    D2

      B                    D3

       

       

      Using datasource Joins

      would give me

       

       

      Month                    User                    Product_QTY          Dept

      Jan 2016               A                            1                         D1

      Jan 2016               A                            1                         D2

      Jan 2016               B                            1                         D3

      Feb 2016               A                            2                         D1

      Feb 2016               A                            2                         D2

      Feb 2016               B                            1                          D3

       

       

      My Current Aggregation in report

       

       

      User               sum(Product_QTY)

      A                    6

      B                    2

       

       

      Its true that my join condition is not at the least granularity

       

      Would it possible to achieve a report as below

       

       

      User               sum(Product_QTY)

      A                    3

      B                    2

       

       

      And

       

      Month                    Product_QTY 

      Jan 2016                  2

      Feb 2016                    3

       

       

      Your advise is highly appreciated, thanks in advance.

       

       

      I would need the join to Department as there would be other Tables on that data.

       

      Message was edited by: Mahadev Somashekhar