Replies

hi Rudi, your formula can fit my calculation at selected cell. THANK YOU VERY MUCH.

Thank You Steve. i managed to do that.

Thank You Steve. i managed to do that.

hi Steve, it is true daily dates in pivot table can be m/d/yy. somehow, i cannot do this with 7 days interval group data. maybe you want to look attached sample. Thanks for your attention.

hi Steve, it is true daily dates in pivot table can be m/d/yy. somehow, i cannot do this with 7 days interval group data. maybe you want to look attached sample. Thanks for your attention.

hi Steve,
1. the pivot table is in F5 and i selected whole column F, Format – cells – number – custom m/d/yy:@ and the 7 days interval group dates remains m/d/yyyy and the dates resides in left as a text would be. if necessary, i will attach a new file as original A1:B4481 of Dates and Net P/L with 7 days interval group pivot table memory exceeds file attachement memory here.
2. Wizard is my first start to set new range in pivot table.
THANK YOU.

hi Steve,
1. the pivot table is in F5 and i selected whole column F, Format – cells – number – custom m/d/yy:@ and the 7 days interval group dates remains m/d/yyyy and the dates resides in left as a text would be. if necessary, i will attach a new file as original A1:B4481 of Dates and Net P/L with 7 days interval group pivot table memory exceeds file attachement memory here.
2. Wizard is my first start to set new range in pivot table.
THANK YOU.

hi Steve and others helpful persons, it is true; 2 lines are 2 text boxes shrunk into ‘line’. i deleted them. THANK YOU.

hi Steve and others helpful persons, it is true; 2 lines are 2 text boxes shrunk into ‘line’. i deleted them. THANK YOU.

hi Steve, two more pivot table questions;
1. can the year format in 7 days interval days grouping be 85 instead 1985 and how to do that? e.g. 11/1/85-11/7/85 instead 11/1/1985-11/7/1985
2. can data range modified after a pivot table created and how to do that? e.g. original data range is A1:C10 and a pivot table created. when data range for the pivot table change to A1:C20, the pivot table does not counts C11:C20. if data range cannot be modified in the pivot table, a new pivot table has to be created with data range A1:C20.

THANKS.

hi Steve, two more pivot table questions;
1. can the year format in 7 days interval days grouping be 85 instead 1985 and how to do that? e.g. 11/1/85-11/7/85 instead 11/1/1985-11/7/1985
2. can data range modified after a pivot table created and how to do that? e.g. original data range is A1:C10 and a pivot table created. when data range for the pivot table change to A1:C20, the pivot table does not counts C11:C20. if data range cannot be modified in the pivot table, a new pivot table has to be created with data range A1:C20.

THANKS.

hi Steve, this is excatly where make me start using pivot table; “Select column A, choose data – text to columns, delimited “. THANK YOU VERY MUCH.

hi Steve, this is excatly where make me start using pivot table; “Select column A, choose data – text to columns, delimited “. THANK YOU VERY MUCH.