T
toecutter
Hi
I have a query that returns a summarised view such as the one below
NOOFACTIONS STATUS PRIORITY MONTH YEAR CATEGORY
2 In Progress High May 2003 OPCOM
3 In Progress Medium May 2003 OPCOM
2 In Progress Medium Jun 2003 OPCOM
1 In Progress Medium Jul 2003 OPCOM
In Excel I can create a Pivot table on this data and have in the
Category fields both Month and Status. When exporting this as a web
page that uses OWC it defaults to a sum operation for noofactions. In
order to show the correct data I need to set the Plot Details records.
But as soon as I do this I lose the ability to have more than one
category field. For example when a drag status over to Priority they
just get swapped.
Any help much appreciated
I have a query that returns a summarised view such as the one below
NOOFACTIONS STATUS PRIORITY MONTH YEAR CATEGORY
2 In Progress High May 2003 OPCOM
3 In Progress Medium May 2003 OPCOM
2 In Progress Medium Jun 2003 OPCOM
1 In Progress Medium Jul 2003 OPCOM
In Excel I can create a Pivot table on this data and have in the
Category fields both Month and Status. When exporting this as a web
page that uses OWC it defaults to a sum operation for noofactions. In
order to show the correct data I need to set the Plot Details records.
But as soon as I do this I lose the ability to have more than one
category field. For example when a drag status over to Priority they
just get swapped.
Any help much appreciated