list box not reflecting the changes

[smilingjohn]

HI All,
I have implemented a pivot table with accumulation expression

rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL)))

If i don't make any product selection then i have all the week start dates displayed properly.
But when i make a product selection then i have missing of weeks . as shown in the figure and screenshot attachment.
Can someone please help me with this to display all the weeks irrespective of my product selections.

Thanks in advance.

[sunny_talwar]

Can you try this

RangeSum(Before(TOTAL Count({<Year *= {">2010"}, Department = {'Cosmatics', 'IT', 'Finance', 'Sales'}>} ID) + Sum({1} 0), 0, ColumnNo(TOTAL)))

[smilingjohn]

Thanks for the reply Sunny, 

When used this change definitely it is populating the missing week dates but with extra  column of zero's and when i tried suppressing the null values it is showing again the same result of missing dates .  please see the attachment 

Do i need to make any change? 

[sunny_talwar]

You might be able to suppress one of the two dimensions, but if won't work if you suppress both... this is just a limitation of the tool. I have not been able to find a solution to this problem yet.

[smilingjohn]

Hi sunny but thing in this is that , the started to populate from 2001 . The condition of set analysis to show th data after 2010 is not working . 

[smilingjohn]

And also the selections are not working , like I am trying to select 2019 from year list box ,but still there is no change in this ...but still the report is showing the data from 2001 

[sunny_talwar]

Try this

RangeSum(Before(TOTAL Count({<Year *= {">2010"}, Department = {'Cosmatics', 'IT', 'Finance', 'Sales'}>} ID) + Sum({1<Year *= {">2010"}>} 0), 0, ColumnNo(TOTAL)))

[smilingjohn]

Thanks sunny now I see the data from 2010 onwards but still the year filter is not working on this , after selecting year 2019 the report still shows the data from 2015 onwards . 

Thanks 

[sunny_talwar]

That is strange that it only shows after 2015... and not 2010? Would you know why that might be?

[smilingjohn]

Sorry 2015 is a typo error, it is showing the data after 2010 ,

But my year selection is not working ,

If I select 2019 from year list box then it should show weeks data from 2019 which is not working now .

Need your help on this