Pivot Table

[soha1902]

Hi All,

I created one report using Pivot Table. Where I am using three columns 1. Product, 2. Active Date and 3. Deactive Date.

I pivoted date field so if date field comes under Active Date and Deactive date then it will show 40 for particular product else null.

See below screenshot:

this report showing the correct data but as per requirement I dont want to include Activated and Deactivated column in report. Please see below screenshot:

If I remove These 2 fields then this report not showing data for Prod A because its having the 2 Active and Deactive date.

Please find the demo app in attachment.

Thanks.

[Anonymous]

Here you go

[soha1902]

You removed Active and Deactive column from Chart1. Now its also not showing data for Prod A. I want to remvoe Active and Deactive column but also want to show the values for Prod A.

[Anonymous]

was that in your "Chart I am Looking"?

I don't see that.

Can you elaborate the requirement?

[arulsettu]

can you post data source like excel

[soha1902]

Any suggestions please.

[tresesco · Accepted solution]

Put your if expression within sum(), like:      Sum(if(Date>=Activated and Date<= Deactivated,40,0))

Does it help?