Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have developed a Qv document to get some stats for Insurance Policies and I have created a pivot table and screen shot is shown below
In my current Pivot table last column remain 0 but I want that 0 to be 1 as shown in my second Pivot table . Kindly help correct my pivot table and I have attached my QV doc h/w plaese.
When Selecting Year=2016 you have no data accociated to Y1=2015. You need to adjust your expression or your data in order to get your desired output in your expression
sum({<YEAR={"$(vN2)"},Y1={"$(vN1)"},RTYPE={"REN"}>}PNOS)
When Selecting Year=2016 you have no data accociated to Y1=2015. You need to adjust your expression or your data in order to get your desired output in your expression
sum({<YEAR={"$(vN2)"},Y1={"$(vN1)"},RTYPE={"REN"}>}PNOS)
You don't have any records where YEAR = 2016 and Y1 = 2015, so that is why the column calculates to 0.
So either your data is different from what you expect, or you have a datamodel issue.
Thanks I got your point