Pivot Chart rendering error

[prat1507]

Hi guys

I have data like this

Year, month, Fruits, Price

2017, JAN, Apple, 10

2017, JAN, Banana, 20

2017, JAN, Mango, 30

2017, FEB, Apple, 10

2017, FEB, Banana, 20

2017, FEB, Mango, 30

2017, MAR, Apple, 10

2017, MAR , Banana, 20

2017, MAR , Mango, 30

2018, APR, Apple, 10

2018, APR, PineApple, 15

2018, MAY, Apple, 50

2018, MAY, Banana, 100

Now I want to build a pivot table

Showing data as

Fruits, Month, Sum(Price)

Now I only want to Show the sum of prices for current FY that is 2018 APR, MAY

but I need to Show all the Fruits available in the data. The sum would be 0 for the Fruits which are not available in current FY. Remember that I dont need any extra data except all Fruits in my pivot chart.

[sunny_talwar]

Is this already resolved?

[prat1507]

No, I remember that was a different question with No selection.

Regards

Pratyush

[sunny_talwar]

No the reason I asked it is because you have marked this as assumed answer... I was not sure if you got what you wanted or are still looking for help

[prat1507]

No I am still looking for help, I dont know how did I mark it. I am travelling right now and maybe it happened due to mishandling of my phone.

[prat1507]

How do I unmark it to an open question?

[sunny_talwar]

May be this

=Sum({<Fruits = p({<Year = {2018}>}Fruits)>}Price)

[prat1507]

Hi Sunny,

So I need all the Fruits to Show in the pivot table but prices only for the current FY.

Regards

Pratyush

[sunny_talwar]

Like this?

[prat1507]

Something like this

Fruits Month Price

Apple Apr 10

Banana May 100

Mango Apr 0

PineApple APR 50

Apple May 15

Mango May 0

Banana APR 0

PineApple May 0