Daily Sales of current month without month selection

[#1]

Hi all

I tried to create a diagram that shows daily sales in the current month without having the current month selected.

I entered following formular in Dimensions / Conditions, etc.

=month(today()) = Month(Fact.Date_Invoiced)

why does it not work?...mmmmmh

Thanks for your help

Oliver

[mdmukramali]

Dear,

Kindly find the attached file.

But you need to create Month filed in the back end.

and use expression

=Sum({<Month={'$(vMaxMonth)'}>}Fact.Net_Rev_EUR)

Thanks,

Mukram

[#3]

hey oliver,

create a variable vCurrentmonth=month(today())

use this variable in the following expression

=sum({<month={"$(vCurrentMonth)"}>}sales)

cheers,

kunal bhattacharjee

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[senpradip007]

Try with this expression

Sum({<Fact.Date_Invoiced = {"$(=Date(Max(Fact.Date_Invoiced),'DD.MM.YYYY'))"}>} Fact.Net_Rev_EUR)