Pivot table not showing correct data , but when it is reverted back to straight table, data is coming fine . Why ?

[shekhar_analyti]

Hi All ,

Pivot table not showing correct data , but when it is reverted back to straight table data is coming fine for a particularly selected date .

Please find the attached qvw .

Thanks & Regards

Shekar

[Chanty4u]

try to add/remove dimensions and check for which it is giving cause?

by that you can able to understand why it is not giving?

[stabben23]

You have no aggregation in Your Expression, This is information which should be Dimensions, thats why.

[YoussefBelloum]

Hi,

I don't know what you're trying to do, but comparing these 2 tables, on the pivot table you have your N dimension missing.

add your N dimension and you will see the same resultat as the one on the straight table

[stabben23]

use maxstring or max on all Expressions and you will see some output here

[stabben23]

Thats absolutely correct, N as Dimension is needed.

[shekhar_analyti]

Hi All ,

I did not get it . When seen in table box for that particular date we have data .

I have attached the qvw .

[shekhar_analyti]

Hi Johansson ,

As per your screenshot , there is only one data for that particular date , however we have two entries for that date , with values of N = 22 and 21 . I mean how to get both .

[stabben23 · Accepted solution]

By adding N as dimension