Cumul Value within stacked barchart

[beck_bakytbek]

Hi Folks, 

i got a question, my datatable does look like:

MonthYear	Projekt	Budget	Expenses
Jan - 2021	A	5	3
Feb - 2021	A	15	3
Mar - 2021	A	20
Apr - 2021	A	25
Mai - 2021	A	30

i try to show the cumul.value for expenses like (see screenshot), but i didn't achieve the expected output,

I am using thix expression: Sum({<Year =  {"<=$(=Today())"}>}), but it does not work

Does anybody have any idea, how to solve this issue?

Thanks a lot

Bek

[MayilVahanan]

HI @beck_bakytbek 

If you want to display expenses only for current Year & Year as Dimension, try like below

If(Year=Year(Today()), Sum(Total Expenses) )

O/P:

[beck_bakytbek]

Hi MayilVahan,
i think, i explained with wrong example, instead the Dim: Year = 2019 i am using the Dim: Jan- 2019

[MayilVahanan]

Hi

Try like below

LOAD *, Month(Date(Date#(Left(MonthYear,3),'MMM'),'MMM'))*1 as MonthNum INLINE [
MonthYear, Projekt, Budget, Expenses
Jan - 2021, A, 5, 3
Feb - 2021, A, 15, 3
Mar - 2021, A, 20,
Apr - 2021, A, 25,
May - 2021, A, 30,
];

If(Month(Today())-1 = MonthNum, Sum(Total Expenses))

o/p: Its display overall expense only for Previous month. You can change expression depends on ur requirement if its changes