Present Month Sales Calculation in pixel perfect

[ecabanas]

Hi,

I have a Pixel perfect report with a full year sales filter . I would like to have a box or label with the current month sales, anyone knows how to do it? that's why because my report is filtered different from this request..

Many many thank's

PS: Is it possible to configure one connection with several filters in the same Pixel report?

Eduard

[lironbaram · Accepted solution]

hi

actually it's quite easy in your case

you can create a formula in the report

that should look something like this:

=text(money( sum({<Month={"$(=max(Month))"}>}Sales), '$ #,##0', '.' , ',' ))

then you can drag and drop your formula to the report

[#3]

on the left side of the tempalte, create a formula which is an expression to get the current month - you can then drag the formula to the coation in the report

e.g. =month(today()) - this would be your formula to get the current month, for example - then drag the formula created onto the report template

Liron's information is much more specific and contains exactly what you are looking for

[#4]

..and yes, you can have multiple filters for a single connection.

The connection points to a specific qvw, so as long as the field, variable etc you want to use for your filters is in that one qvw, it is not an issue