Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
we have week and year as a parameter.
bucketing - pie chart ( 5 different buckets) - on YTD
client making transactions based on the bucket ytd
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%
Hi Sunny,
Have provided all he details.
Can you let me know of any possibilities?