Total in pivot table

[francisvandergr]

I have a formula in the expression of a pivot table :

The formula is:   sum(Amount) / Price.

My problem is that i see no total at the top of the column. i have selected the option "subtotals on top" . I don't want a straight table of this. has anyone an idea ?

[kaushiknsolanki]

Hi

   Its a pivot table. So to view total you have to select partial total checkbox. You will find that in Properties-> Presentation -> Click on the dimension for which you want total and click on Partial Total.

   In same tab you can define the top or bottom position of total. From Subtotals on Top and Subtotals at Bottom

Regards,

Kaushik Solanki

[#3]

Hi,

You can have subtotals on top in a pivot table. Please see attached doc.

Regards

Arun

[francisvandergr]

Sorry bu ti have already selected Partial Total on my dimension Article. For another expression "Amount it works". But nogt for this expression

[kaushiknsolanki]

Hi

    Have a look at this example. If this doent work send us your qvw file.

Regards,

Kaushik Solanki

[francisvandergr]

Hereby i send you my qvw. The problem expression is the expression "Aantal"

[kaushiknsolanki]

Hi,

    Here is your solution.

Regards,

Kaushik Solanki

[francisvandergr]

It is not the good value. The problem i see the not the result of the totals of the row. Fo rperiod 1 the total is about 128. Now i see 33.17

[#9 · Accepted solution]

try this one

[francisvandergr]

Thnx indeed this is the solution. I understand!