Some data is not displaying in Pivot table

[Rajesh]

Hi All,

I have created Pivot table and converted it to CrossTable view with 2 dimensions and 2 measures

Dim1 : Week

Dime : WeekDay

Measure1: Day

Measure2 :

if(aggr(count(DISTINCT number), Week, WeekDay)>2,

   aggr(count(DISTINCT number), Week, WeekDay)& ' Records'&chr(13)&chr(13)& concat(number & '- ' & short_description, chr(13)),

concat(number & '- ' & short_description, chr(13))

)

in this below pivot table missing some days as i marked one.

i would like to show the missing days

Can any one suggest the solution.

Thanks

Rajesh

[sunny_talwar]

Would you be able to share a sample to look at this?

[Rajesh]

Thanks for reply Sunny but have Confidential data.

[sunny_talwar]

Mocked up sample data or my be scrambling the data?

Preparing examples for Upload - Reduction and Data Scrambling

[ogautier62]

Hi,

for these days, is there any value ? (number and description)

I don't think so

regards

[Rajesh]

Hi Sunny,

Please find the attached qvw.

[Rajesh]

Hi Olivier

days are in numbers like 1 to 30

[ogautier62]

yes but for these days, does exist value for other measure ?

[sunny_talwar]

But it seems to be working fine in the sample attached, right?

May be try with this expression for Day

Only({1} Day)

[Rajesh]

Yes some days don't have measures