Hi,
i have data of following structu
timestamp state duration
1.1.2005 12:10 A 10
1.1.2005 13:15 A 10
1.1.2005 15:35 B 20
2.2.2005 9:01 A 10

and need them sum in pivot table according days(months):
1.1.2005 A 20 50%
B 20 50%
Subtotal 40 100%
2.2.2005 A 10 100%
Subtotal 10 100%

the problem is that i can define the % only as "% of total" or "% of
column". I need one day being considered as 100%.
Can anyone help me out?
Thanks a lot
Hana