Mark Polino's Blog, page 338

August 1, 2011

Weekly Dynamic: Filtering a Pivot Table with a Formula - Technology

I was playing with a pivot table built from GP data the other day and I wanted to control the months that would show based on a field. For example, I only wanted to see months 1-7 since we're in July. Typically you could just filter the pivot table to exclude months 8-12 but then every month you have to change the filter and you have to change it for every pivot table.

It just so happens that I had seen this great CFO.com article on Filtering a Pivot Table with a Formula.

This is basically a hack that compares the data to the control field and then uses that result as a true/false filter. Filter the Pivot Table on True/False and you get formula controlled Pivot Tables.

It's very slick.



 •  0 comments  •  flag
Share on Twitter
Published on August 01, 2011 06:00

July 27, 2011

Upgrade Details for Dynamics GP | Interesting Findings & Knowledge Sharing

Sivakumar puts links to Upgrade Details for Dynamics GP all in one place. Make sure to say thanks for this resource.



 •  0 comments  •  flag
Share on Twitter
Published on July 27, 2011 10:00

Going Vertical with Dynamics GP - Mad Mark, the GP Road Warrior

You can tell that I'm back from vacation because I've got a new article up. Over at my Mad Mark column on the Microsoft Dynamics Community site, I've got a look at Going Vertical with Dynamics GP with an example for media related industries.



 •  0 comments  •  flag
Share on Twitter
Published on July 27, 2011 09:00

DynamicsBlogger: Analytical Accounting: Dimension Code Macro

Janakiram M.P. ads more Analytical Accounting knowledge with a new Accounting: Dimension Code Macro.



 •  0 comments  •  flag
Share on Twitter
Published on July 27, 2011 08:00

Dynamics GP Land: Reconcile to GL Oddity

Christina Phillips found another oddity in the GP Reconcile to GL functionality. I've found plenty of them too which is why I push The Closer so much. Frankly, it not only does more, it's better quality product for reconciling subledgers to GL.



 •  0 comments  •  flag
Share on Twitter
Published on July 27, 2011 06:00

July 26, 2011