Report design question

In the attached screen shot you will see one of our report by Project and by Time. This module is dimensioned by Time, Project List, Function list and Funding type. We have data for actual, forecast and etc.

We need to see Project ID and Project Status information on this report. But if I add them as line item, they show up under every month. I tried hard coding the module view but people can select the month or year on the report.

Project ID is a property in the Project list. So I'm not sure if there's a good way to display that in this situation? Any insight would be helpful. Thanks.

Accepted answers

ChrisAHeathcote

Try adding properties to the list and when creating the export action set up export labels to include list properties.

All comments

ChrisAHeathcote

@lilasququ

Create a systems module dimensioned only by project. Add line items for the two project properties, format them by the relevant lists and populate them as per each project.

Publish this additional grid alongside the time series data.

lilasququ

Alongside? do you mean in a different card? Users want to export the one grid as a report so it cannot be separated.

Is there a way to them combined?

ChrisAHeathcote

Try adding properties to the list and when creating the export action set up export labels to include list properties.

lilasququ

Thank you. So in order for the export to happen it seems I will need to create a button on the UX page. Users only have access to the dashboard. Is there not a solution to include that on the grid or in the export from the grid?

ChrisAHeathcote

No.

The best way to show time series data alongside non time series data is to use two cards.

lilasququ

Thank you

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…