Hello everybody,
I am working on a PivotTable. I have to insert 2 elements calculated in a column field and after that grouping on the other column field "DATE". When I make the grouping, I get a message of error that is driving me crazy.
You can see an example of what I get. In the sheet "Pivot_problem" I inserted the calculated elements in the column field "fail/pass". If I group on "DATE" the get the months instead of the days, the message appears.
Can someone help me please? Thanks.
mela
Last edited by VBA Noob; 09-21-2008 at 11:19 AM.
Please, can anybody help me with this?
It is very important for me guys...thanks
Does the attached help?
It is easier to break the info in a single column like your 'pass/fail' into a qty column for each type of value then it is easier to do arithmetic/percentages on it.
Thank you very much for your help, steven1001.
I will try to resolve the problem as you have suggested.
Thanks
Mela
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks