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,

Take Fact.Date_Invoiced as dimension.

and in Expression you can include the set analysis to filter the data for current month.

if it's not clear than attach the sample file so that we can help you.

Thanks,

Mukram.

[ashwanin]

Please  provide some example.

[ashfaq_haseeb]

Hi,

Check if this helps.

If not, Try to post sample data with expected output to get exact output.

Regards

ASHFAQ

[#5]

Hi all

sorry, I don't understand why this is not working. Added a short test file...

Thanks for your help.

Oliver

[ashfaq_haseeb]

Hi,

Try like this

=Sum({<Fact.Date_Invoiced = {'$(=date(Max(Fact.Date_Invoiced)))'}>} Fact.Net_Rev_EUR)

This was your expression

=Sum({<Fact.Date_Invoiced = {'$(=Max(fact.Date_invoiced))'}>} Fact.Net_Rev_EUR)

Set Analysis is case sensitive.

Your field Fact.Date_Invoiced does not match with  {'$(=Max(fact.Date_invoiced))'

Have a look at attached application too.

Regards

ASHFAQ

[its_anandrjs]

Hi,

You have to write because some field name missing try this

=Sum({<Fact.Date_Invoiced = {'$(=date(Max(Fact.Date_Invoiced)))'}>} Fact.Net_Rev_EUR)

Regards

Anand

[#8]

Hi all

Thanks for your help.

Now I get the revenue of the max day, but I want it of the max month per day...

=Sum({<month(Fact.Date_Invoiced) = {'$(=date(Max(Month(Fact.Date_Invoiced))))'}>} Fact.Net_Rev_EUR)

this does'nt work, the result is 0

[ashfaq_haseeb]

Hi,

Can you close this thread and open new one for another request.

Regards

ASHFAQ

[#10]

Why, still looking for "Daily Sales of current month without month selection"...and the solution is close but not there, yet!