How to change the header of a dataview between forecast and actuals

Julian Boelsen
Julian Boelsen Active Partner
Fourth Anniversary 25 Up Votes Level 100: Foundations of Building in Board
edited August 2020 in Platform
Hello everyone,

I am building right now a 3+9, 6+6,... forecast and I want to change the header of the dataview accordingly to forecast and actuals (e.g. 3+9 forecast first 3 months actual, last 9 months forecast).  The cube can be the forecast cube for both actuals and forecast. It is just necessary to display the header correctly. Is it possible to do this in one dataview?

I've got a lock cube for the data entry that is 0 to enter some digits for the forecast.

Thank you!

Cheers,


Julian

------------------------------
Julian Boelsen
Consultant
better decisions GmbH
Germany
------------------------------

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited August 2020
    Dear @Julian Boelsen,

    the header being displayed depends on the block you are using. If all your columns refer to the same cube the columns' header will display the cube's name (or the block's heading respectively).
    So, you'd need different blocks to display different header information. From my point of view, it would be best to use a "detail by" (Month) option and references.
    Let me know if you need further assistance.

    Kind Regards,
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------