Pivot Table showing Wrong Total

[sarfaraz_sheikh]

Dear All,

Why My Pivot table is showing wrong total.....please check suggest me where i am doing wrong....

My QVW and Snapshot is attached here.

Sarfaraz

[sarfaraz_sheikh]

Dear all,

Below is the snapshot for the same...

sarfaraz

[rubenmarin]

Hi Sarfaraz, that document doesn't have any chart, seems you uploaded before saving or uploaded another document.

[MK_QSL]

Ruben.... No data also...

[rubenmarin]

Right.

Anyway I think Sarfaraz is looking for an expression in second table like:

Sum({<D_NO={"*"} SALARY)

or

Sum({<D_NO*={"*"} SALARY)

or

Aggr(Sum(SALARY), D_NO)

Well it seems not, problem was the first table.

[sarfaraz_sheikh]

Please find the attached QVW .

Sarfaraz

[MK_QSL]

Hi Sarfaraz,

What should be the Total Salary as per your requirement ?

[rubenmarin · Accepted solution]

Hi, maybe:

=Sum(Aggr(Sum(SALARY), Remarks))

BTW, I think your original values were correct, as this is duplicating salaries located in more than one Remark

[sarfaraz_sheikh]

Hi Manish,

The total salary should be sum of all rows  in both the table...However one table showing correct total and onother one is showing wrong total .

sarfaraz

[sarfaraz_sheikh]

Hi Ruben,

Your solution is working as expected ....Thanks a lot for help !!!!!!

Sarfaraz