Share
ReportHi Everyone,
i'm new in GP reporting and i have to build the below report
below is report fields definition
| Field | Level | Source | Calculation |
| Name | Row | Staff Trx Dimension | N/A |
| Company | Row | Company from where the row data is being generated | N/A |
| Division | Row | Division Trx Dimension | N/A |
| Department | Row | Department Trx Dimension | N/A |
| Ticket Expenses | Column | Travel Expense Trx Dimension | Acual YTD |
| Hotel expenses | Column | Travel Expense Trx Dimension | Acual YTD |
| Transportation | Column | Transportation Trx Dimension: Transportation Abroad | Acual YTD |
| Phone | Column | Number Trx Dimension: General Telecom Exp | Acual YTD |
| Personel Catering expenses | Column | Travel Expense Trx Dimension | Acual YTD |
| Visas Expenses | Column | Travel Expense Trx Dimension | Acual YTD |
| Invitations & Receptions | Column | Travel Expense Trx Dimension | Acual YTD |
| Public Relations | Column | Travel Expense Trx Dimension | Acual YTD |
| TOTAL As of July 2017 | Column | Calculated Field | Sum (E:L) for Current Year |
| YTD AS OF July 2016 | Column | Calculated Field | Sum (E:L) for Last Year |
| Budget FY 2017 | Column | YTD Budget | |
| YOY % | Column | Calculated Field | (M7-N7)/N7 |
| % Budget Achieved | Column | Calculated Field | M7/O7 |
is it possible to build it in Management reporter or i should use ssrs?
also kindly advise how to proceed with any of the above solutions
appreciate your assistance
regards,
Georges
*This post is locked for comments
All responses (
Answers (
291,280
