Skip to Content
0

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

Jan 24, 2017 at 02:11 PM

15

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jan 24, 2017 at 02:19 PM
0

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)

Share
10 |10000 characters needed characters left characters exceeded