P&L Variance List

Hi,

Question please. What is the best practice if I need both the columns and rows as a line item because I need to calculate the variances and the difference to maintain the clients preference on the presentation. Below is an example.

thank you.

Accepted answers

rob_marshall

@DMManalili

Have you seen this article?

https://community.anaplan.com/t5/How-To/Variance-Analysis-With-Native-Versions-Made-Easy/ta-p/98336

Rob

All comments

rob_marshall

@DMManalili

Have you seen this article?

https://community.anaplan.com/t5/How-To/Variance-Analysis-With-Native-Versions-Made-Easy/ta-p/98336

Rob

DMManalili

I am not using a Version, the report pertains to actual data. The variance pertains to actual from previous months and years. Thanks.

rob_marshall

@DMManalili

The same theory applies, using a line item subset will be your friend.

DMManalili

Thank you 🙂

Quick Links

Can you help?

Unanswered questions

Anaplan Level 3 User Story 1.11
"Regarding User Story 1.11: Should the module dimensionality be restricted to the Account level, or is it a requirement to include the Product grain as well?"
export and filter button
Hello, I have a table displayed on a UX page, and I would like to add an export button that allows users to export the data exactly as shown in the table. Ideally, the export should reflect: applied filters sorting any user selections or context Is there a way to export data dynamically from a UX table so that it matches…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…