Month and YTM Pivot

**nagesh.tvsr** · 07-26-2016, 03:31 AM

Hi,

Need help in making the pivot (Month Budget Vs. actuals as well as YTM Budget Vs. Actuals) as per the details given in the attachment.

Pl. help.

Thanks,
Nagesh.

**oeldere** · 07-26-2016, 03:59 AM

to get you started, maybe like this.

**stasinek** · 07-26-2016, 07:30 AM

See for such a solution. Used this data source created by oeldere. I've added a calculated field that shows Variance in%.

Month and YTM Pivot

LinkBack

Thread Tools

Rate This Thread

Display

Month and YTM Pivot

Re: Month and YTM Pivot

Re: Month and YTM Pivot

Thread Information

Users Browsing this Thread

Similar Threads

Pivot table with new data each month, last 12 or 24 months wanted in pivot

Month by Month Pivot Table

[SOLVED] Pivot Table Not Grouping by Month for Latest Month (groups > 7/20/2013)

Goup date in pivot table from 16 of the month to 15 of the following month

How to add Month-on-Month and Year-on-Year %Variance into a pivot table

[SOLVED] Reverse Pivot Table - Convert budget rows with 12 month columns to 12 rows - 1 per month

[SOLVED] Pivot: Replace month numbers with month names and sort by fiscal year

Bookmarks

Bookmarks

Posting Permissions