Calculating YTD based on the dynamic year and week parameter

[ishanbansal1204]

Hi All,

I want to calculate ytd value for the client registered. i have filters on week and year.

my expression is

IF (Aggr(Sum({ 1 <WEEK={"<=$(=Max(WEEK))"}>}COUNT_CLIENT),[CLIENT]) = 1, '1 Transaction')

the above expression is working fine for week. but i need to add year condition as well. how shall i do that?

what if the user select only week and not year so default it should take max year available in the filter.

[ishanbansal1204]

[sunny_talwar]

Ishan -

I am not sure how else to help brother. I have been asked few times if you can share a sample. If you are unable to share than I hope someone else may be able to offer a better advice based on the facts that you have provided above

Best,

Sunny

[ishanbansal1204]

we have week and year as a parameter.

bucketing - pie chart ( 5 different buckets) - on YTD

client making transactions based on the bucket ytd

[ishanbansal1204]

In Detail.

This is at a YTD level.

if user is not selecting any week nor year as a parameter then default should be max week and max year

if user is selecting a week and not year then it should consider max year

if user is selecting year then it should consider max of week as default.

based on the transcations by the customer during the YTD bucketing has to be created and has to be displayed in the pie chart.

eg :

bucket 1 - 10%

bucket 2 - 50%

bucket 3 - 30%

bucket 4 - 10%

[ishanbansal1204]

Hi Sunny,

Have provided all he details.

Can you let me know of any possibilities?