Values showing double after using IntervalMatch table

[Rajesh]

Hi All,

I am trying to implenting the calendar view and Gantt chart using Pivot table.

To display the data in Gantt chart i have created IntervalMatch table that is displaying data in it as expected, but when i trying to display

in Straight table or Pivot table values showing very high Count.

i couldn't rectify it.

Can any one suggest the solution.

Please find attached QVW.

Thanks

Rajesh

[sunny_talwar]

I wish you provided more clearly what you were looking to do... this was just a educated guess that I had to make that on one side you want to see all dates highlighted from start to end (pivot table on sheet2)... whereas the other chart needed to show based on the start date only... Please try to explain clearly what you are looking to do and not expect us to know what you might need.

Best,

Sunny