Skip to Content
avatar image
Former Member

How to use sum for a specific dimension from the whole dataset?

Hi,

I have a scenario in my report where I need to sum up the values based on the dimension that I provided. But I am having some problem.

Let me explain you with an example,

Objects that I take from the query are id,fees,fees1,fees2,fees3.. etc...

The data set would look like this

idfeesinvoicefees211001100122250111111200110012230025011100

if I take id and fees alone, the sum for fees is 150 and if I add other dimensions in the report it increases. Can someone give an good idea to implement this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 24, 2017 at 02:19 PM

    if you want to sum the fees based on other dimension also which are not tin the table view then use FOREACH function to include those in the calculation.

    sample like

    =sum(fees) foreach (otherdim1;otherdim2)

    Add comment
    10|10000 characters needed characters exceeded