Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
..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