Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
User selects 2010 in a list box and March in another list box. I need a chart (straight table) that in one column show March's total sales and in the second column shows YTD sales.
Seem to be brain dead today
Help,
Stephen
If you are forcing them to select a month, then that is all you would need for March.
For YTD, why don't you just use set analysis and turn off the month selection - keeping all else the same. (assuming your month field is just Month)
Sum({$<Month=>} yourAmount)
$ = current selections
<Month=> = removes Month selection
ws
By the way, the user also selects a territory from a list box.
If you are forcing them to select a month, then that is all you would need for March.
For YTD, why don't you just use set analysis and turn off the month selection - keeping all else the same. (assuming your month field is just Month)
Sum({$<Month=>} yourAmount)
$ = current selections
<Month=> = removes Month selection
ws
I think this:
March 2010 = sum(Sales)
March 2010 YTD = sum({<Month={"<=$(=Month)"}>} Sales)
wshpuntoff worked.
Thanks.
Hi wshpuntoff
Can this be done in a Cyclic Group? If yes then please help me out!
Thanks
Attitude
Hi John
Can it be done used as one of the field along with Year/Quarter/Month/Week. If it can be done then please let me know on that.
Regards
Attitude
You can use the function GETCURRENTField and pas your Cyclic group Name.
Thanks asomani! This is something similar to what I was looking for but not very sure whether it give the expected result or not.
Could you please give me more detail on how to use this inside the Cyclic Group please.
Are you expecting me to do something like below? For your information as "getcurrentfield" gives the field which is selected in the group I have passed '=''' for the YTD. Hope I am doing the right thing here. If not please do let me know.
if(getcurrentfield(MyGroup)='=''',Count({<[Month] =, [Year] = {'$(vMaxYear)'}>} ID),Count(ID))
Correct. Now based on this you know what Column you viewing and what expression you should be consider
Regards,
Amit