Hi all,
I may have a bit of a strange question - is it possible to create a pivot of two fields (in rows), over months/weeks (columns) and after their rowTotals have another total? This additional total would be row total for a third field but I just need the row total, not values over columns.
Here is the link to an example file which will make it perfectly clear.
Table1 is what I know how to do and is perfectly clear
Table2 (below this one) is a pivot with an extra column added manualy.
Is it possible to recreate this table2 without manually adding and calculating this third column?
Many thanks!
I may have a bit of a strange question - is it possible to create a pivot of two fields (in rows), over months/weeks (columns) and after their rowTotals have another total? This additional total would be row total for a third field but I just need the row total, not values over columns.
Here is the link to an example file which will make it perfectly clear.
Table1 is what I know how to do and is perfectly clear
Table2 (below this one) is a pivot with an extra column added manualy.
Is it possible to recreate this table2 without manually adding and calculating this third column?
Many thanks!
