Data is aggregate for particular month

[prma7799]

Hi All,

We have one table in that we have used calculated dimension.

My question is I have product and it product have  invoice date in the chart when I am taking calendar date range for one particular product the data is coming right but it is coming with aggregate format.

Say suppose product  OBI-X have invoice date is 27-09-2014 then data should come from SEP to March but data is come only for Sep.

Thanks

[tresesco]

How does your expression look like? Could you share sample qvw?

[prma7799 · Accepted solution]

Hi tresesco‌,

Thanks for your quick response.

I got the solution I just remove all condition which was apply for all dimension.

=If(date([First Invioce Date],'DD-MM-YYYY')>=Date(vStartDate) and date([First Invioce Date],'DD-MM-YYYY')<=Date(vEndDate),

Product)

And simply apply above formula for First Invioce Date And get expected output.

Is anything else I will surly disturb you.

Many thanks