3/5

3/5

Karim Lameer Karim Lameer

Karim Lameer

Anaplan Expert | Connected Planning for Biotech | DSI Consulting | Fail Fast, Fail Cheap

发布日期: 2023年3月24日
+ 关注

Why is it useful?

Unable to aggregate this way without an intermediate step.

How To?

Starting off with a small list of fruit names with a top level item.

No alt text provided for this image

The time dimensioned module should have two line items. One is the value to aggregate and the other the list item it is being aggregated by.?

No alt text provided for this image

The aggregation will be done at the list level. So in the module dimensioned by the list.

Create two line items here, the first one with a timescale. This will be used to do the aggregation. The next will be used for a TIMESUM().

No alt text provided for this image

The first line item will do a normal time sum. As this has a timescale, it will bring the summaries into the non timescale dimensioned model.

The next model using time TIMESUM will aggregate this.

No alt text provided for this image

要查看或添加评论，请登录

Karim Lameer的更多文章

  • 5/5
    2023年3月29日

    5/5

    Why is it useful? It gives you better access into how the items within a list are organized. How is it done? You can…

  • 4/5
    2023年3月27日

    4/5

    Why it is useful? User filters are better than general filters. When you change a general filter, the views change for…

  • 2/5
    2023年3月22日

    2/5

    Why is it useful? If a list has a sequence of items that you need to add to, you will need a starting number based on…

  • 1/5
    2023年3月20日

    1/5

    Get the start and end period (week, month, year) in a modules time frame. Why is it useful? Some calculations are done…

  • Quick tips for building better financial models
    2023年3月16日

    Quick tips for building better financial models

    Whether you are building a financial model for a business or a personal budget, building models in Excel is both a…

  • Monte Carlo Simulation Sales Forecasting
    2020年12月10日

    Monte Carlo Simulation Sales Forecasting

    This article was originally published on the Intellisolve blog and looks at how to use a Monte Carlo simulation for…

    1 条评论
  • Anaplan vs Spreadsheets
    2020年7月13日

    Anaplan vs Spreadsheets

    Lotus-123 was the first widely used spreadsheet application. One of the first “killer apps” that drove the sales of…

  • To Find the Right Forecasting Method, Try All of Them
    2020年2月10日

    To Find the Right Forecasting Method, Try All of Them

    Cassandra in Greek mythology was given the gift of foresight by Apollo in exchange for favours. She took his gift and…

  • Using Python to Solve the Monty Hall Problem
    2019年9月29日

    Using Python to Solve the Monty Hall Problem

    Monty Halls was a game show host of Let's make a deal. The game consisted of presenting a contestant with a choice of 3…

    2 条评论
  • A Data Mining Methodology
    2018年8月1日

    A Data Mining Methodology

    Data mining is now a mature science, and with all things that have been practiced for long enough, it can be broken…

社区洞察

其他会员也浏览了