Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training

Sage MAS Intelligence

Reply
Topic Options
bknud2550
unidentified user
bknud2550
Posts: 1
Registered: 08-29-2011
0

Pivot Table Report Filters Are Over-Written

Options

08-29-2011 01:48 PM

I wish to create a report and pull in the raw data 1 time and perform multiple pivot tables with Excel report filters.  I would then use the results of the multiple pivot tables in my final report by cell referencing to the specific pivot table worksheets.  My problem is the Excel report filters keep getting over-written every time I run the report from SMI.  I know that I can create multiple reports with multiple filters and pull them in as a union report but I was hoping to gain some efficiency by not reading the same file multiple times.  Any advice?

 

Barbara

Message 1 of 2 (56 Views)
 
Reply
TomTarget
Sage MAS Partner
TomTarget
Posts: 1,752
Registered: 11-02-2008
0

Re: Pivot Table Report Filters Are Over-Written

Options

10-03-2011 01:03 PM

Welcome to the forums.

 

I believe you can create all of your pivot tables within the same template.   It doesn't have to be one pivot table per template.

Thomas H. Rogers, C.P.A.
Target System Technology, Inc. - Spokane, WA -
The best solution often comes not from answering the question asked, but understanding WHY the question was asked.
Message 2 of 2 (33 Views)
 
Reply