Refresh data on Source data change
Hi,
I have a report where I need to display data present in the following table.
I am using Spread sheet control for showing the data which is present in the excel worksheet.
_________|_Completed__|_Started_|Not Completed_|__Total__|
Project 1|___20______|__30____|____10_______|_60_____|
Project2_|___30_____|__20____|____10_______|_60_____|
Project3_|___10_____|__30____|____10_______|_50_____|
Total____|___60_____|__80____|____30_______|_170____|
The count for different status values is calculated from the source data which is present in another worksheet.
Now there are only 3 distinct projects but if the source data gets modified and number of projects is increased to 5 then the above table will not reflect this change.
How can I implement this in xcelsius??
How can I create a Pivot table like structure so that the distinct project values will get refreshed on source data refresh and the last row of the table will be the total of all status values?