Hi
Regarding Pivot - Same Month Coming Multiple Times in Pivot
Pivot - Same Month Coming Multiple Times in Pivot. Pls. find attached the excel sheet & screenshot for your kind reference. Requesting your support for the same.
Pls. Note: I don't not posted this query in any other excel forum. This is a genuine query.
Pivot-Month-MultipleTimes.jpg
Your "Month" values are actually individual dates so you're getting one instance per unique date.
Leaving your source data as-is, right click on any "Month" value in your Pivot --> Group --> Month (& Year if desired)
Thanks for the response. Is it possible to show me how to convert individual dates to month in the excel data source. So that while plotting Pivot, the same month will not come multiple times. Pls. Help.
Perhaps if you could show us an example of your plot, we could be of more help.
XLent's directions will prevent the same month from appearing multiple times in the pivot table, without having to make any changes to the Dataset1 sheet.
Also please update your profile as .xlsx files are not supported by the 2003 version of Excel.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks