totals in table

[Anonymous]

Hello,

I have then next table and i would like to know how to calculate correctly the sales.

		sales
201701	Real	5
	Objective	9
	Total	9
201602	Real	2
	Objective	6
Total		14

It is posible to make the total like this?

		sales
201701	Real	5
	Objective	9
	Total	9
201602	Real	2
	Objective	6
Total	Real	7
	Objective	14

thank you

[Anonymous]

Pablo,

Go to the presentation tab and check partial sums for your yearmonth dimension and another dimension at level2.

[krishnacbe]

Hi,

Check the sample attached

[Anonymous]

still makes the sum of the objective

[Anonymous]

Create a inline table

Dim1:

Load * inline [

Dim

1

2];

Now use this as dimension

pick(Dim,<Your dimension>,'Total')

[#6]

Hi,

Can you please try this expression once.

Sum(Total <Type> Sales)

Thanks,