reg weeks to be displayed in chart/summary table even if there is no data in that week

[#1]

Hi All,

User wants to see the every week (row) even if the data is not present for that week.

Please find the screenshot as attached.

For Example:

Lets assume we have fiscal week column which will have the following values W-1,W-2,W-3,W-4 .. etc...and there are other

3 columns along with it. All are dynamic values including fiscal week.

In general If there is no data for any week that row won't be displayed in summary table. but the user is asking all weeks should be displayed irrespective of  data (even the data is not there)

Can anybody help .. thanks in advance.

Thank you,

Srinivas K

[prieper]

use the "Show All Values"-option under Dimensions

HTH Peter

[#3]

Hi Peter, thank you for quick reply.

I applied Show All Values option in Straight table but its not working because we have applied Suppress Zero values option. (as per user request/requirement).

User Requirement: If we select last 5 weeks, user wants to see 5 weeks in straight table if the data is present or not.

Do we have any alternative please let me know.. thanks in advance

Srini