Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you try this
RangeSum(Before(TOTAL Count({<Year *= {">2010"}, Department = {'Cosmatics', 'IT', 'Finance', 'Sales'}>} ID) + Sum({1} 0), 0, ColumnNo(TOTAL)))
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?
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.
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 .
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
Try this
RangeSum(Before(TOTAL Count({<Year *= {">2010"}, Department = {'Cosmatics', 'IT', 'Finance', 'Sales'}>} ID) + Sum({1<Year *= {">2010"}>} 0), 0, ColumnNo(TOTAL)))
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
That is strange that it only shows after 2015... and not 2010? Would you know why that might be?
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