YTD and Set Analysis

[#1]

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

[#2]

By the way, the user also selects a territory from a list box.

[#3 · Accepted solution]

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

[johnw]

I think this:

March 2010 = sum(Sales)
March 2010 YTD = sum({<Month={"<=$(=Month)"}>} Sales)

[#5]

wshpuntoff worked.

Thanks.

[#6]

Hi wshpuntoff

Can this be done in a Cyclic Group? If yes then please help me out!

Thanks

Attitude

[#7]

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

[#8]

You can use the function GETCURRENTField and pas your Cyclic group Name.

[#9]

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))

[#10]

Correct. Now based on this you know what Column you viewing and what expression you should be consider

Regards,

Amit