Volume as per current month and Revenue as per YTD
I need a help in finding out solution for my issue i.e. I have calculated my Volume as per current period(201603) selection and Revenue as per YTD(201603, 201602, 201601) logic. I am able to get the values for corresponding fields. Issue is that when I am selecting current period(201603), I should see only 2 rows(2nd table shown below), but I am getting all the rows because of my YTD logic for Revenue calculation. In conclusion I should see customers as per current period selection only not as per YTD. Please help on this.
Re: Volume as per current month and Revenue as per YTD
Thanks for your response guys. Sorry for late reply.
I have already done the YTD logic, but my issue is I want to see my data as per current selection only, as I am using YTD logic, it is pulling all the customer name and showing volume as 0 which does not fall under current selection for volume. Please find below example from one of your qvw. Here my requirement is to not show row for Pineapple as it does not have data for current month selection.
Somehow the solution you provided is not working up for me. And I am not going to use period on my chart. Please suggest.