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.
Would you be able to share a sample where we can see the issue?
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 onward which is not working now .
It is showing the data from > 2010 onwards irrespective of year selection
Need your help on this
Hey John, any chance you can attach the QVW for this one, or a sample of one that shows the issue? I agree with Sunny, I think that is going to be necessary in order for anyone to try to work on it further, as it would seem there may be something going on in your data model potentially... If you have confidential info in the app, you could scramble those fields provided they are not ones we need to be able to trace, you can do that via the Desktop Client in the Settings\Document Properties\Scrambling tab...
Regards,
Brett