Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
By adding N as dimension
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?
You have no aggregation in Your Expression, This is information which should be Dimensions, thats why.
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
use maxstring or max on all Expressions and you will see some output here
Thats absolutely correct, N as Dimension is needed.
Hi All ,
I did not get it . When seen in table box for that particular date we have data .
I have attached the qvw .
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 .
By adding N as dimension