Dynamic Calculation Flag

[Anonymous]

Hello everyone,

I am new to the forum and have already had a few search attempts, which unfortunately were not very successful.

That's why I'm trying a new post.

I have a fact table. It contains the following information.

Year	Month	Article	Revenue Act	Revenue LY
2024	1	123	500
2024	2	123		500
2024	3	123	500	500

Now the problem:

I should build a dynamic flag, if I select a month in the dashboard. e.g. "1" then the flag gets the value "0". Since the row had no value in the last year. If I select the month "3", then I get a value of 1 in the flag.

This would then result in the following table:

Year	Month	Article	Revenue Act	Revenue LY	Flag
2024	1	123	500		0
2024	2	123		500	0
2024	3	123	500	500	1

However, the flag is now static. I would like the flag to be dynamically set, if I select more than 1 month in the dashboard.

Example:

I select the first 3 months of the year. Then the article was sold in the first 3 months and should be taken into calculation.

I would like to be able to continue calculating with the flag later.

Thanks in forward!

Cheers

[Anonymous]

Hi @Anonymous ,

I don't quite understand what you mean, is the "1" January or 1 month, which of the "1's" are selected to return 0, and what does the 1 in tag mean.

Best regards,
Community Support Team_ Scott Chang