Hi Greg
Couple of issues. First the date in the data is actually text of something
that looks like a date, followed by a space. As such it cannot easily be
converted to a true date. To convert it you would need to st up a new
column and use =DATE("20"&MID(A2,7,2),LEFT(A2,2),MID(A2,4,2))
The pivot is using the Date Mailed twice. First as a filter and then as a
row label. That is why it gives it two different names. It seems to
generate the second because the first looks like a date. I am not sure
about this. When I had added my new column and called it DateDate I could
generate a pivot table without the Date Mailed2 appearing.
I really don't understand why it seems to autogenerate weeks as the
interval rather than days.
Regards
David Grugeon
On 1 November 2012 08:33, Greg2011 <gdbar...@googlemail.com> wrote:
> Hi,
>
> I have a pivot table that includes a field in the 'PivotTable Field List',
> that is not in the source data. It appears to be a copy of a Date field
> that has somehow been grouped by week (e.g. Week 1, Week 2, etc). I've had
> a play around with the Group Field function in Options but to no avail (I
> can only group them by periods).
>
> It's driving me a bit mad. Any help would be much appreciated.
>
> I've attached the file. The extra field is called 'Date Mailed2'.
>
> Many thanks
>
> Greg2011
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
