Ok strom I think I can help you
First in your cross tab above the line which includes your date create a new one.
Then create this var FormatDate(<Transaction Date> ,"yyyymm") and add this var in your new line
Sort this new var by alphabetical order and then delete this line : your tab...
I think this could help you :
Create a table with your two columns WillCod and Mirror.
Then break on the mirrorWillCod, as said by Subha, delete the unwanted lines and delete finally the mirrorWillCod column then filters or alerts:
This looks like that :
1 a -> a (filter on a or alert)
2 a...
Hi paul,
I think I have a solution to your problem.
To calculate your YTD plan sales create a new object which returns 1 for all the dates before CurrentDate() and 0 for all the dates after CurrentDate(). Then to calculate your YTD multiply this new object with your YTD formula.
Only the dates...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.