Skip to Content
author's profile photo Former Member
Former Member

Cross tab value to be referenced outside of the table

Hi All,

I have 4 cross tabs in a single report. But the sum from the first table need to be referred in all the other tables. Is there anyway I can store the result in a variable and used it outside of the table anywhere within the report?

Thank you,

Arthur.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2016 at 02:33 PM

    Amit ,

    I am using a Variable to store the result . I have created a variable of measure as Revenue_CY and the formula is

    Revenue_CY=Sum([Level1AmountCY]) Where([P&L Lvl 01 Order] ="001") In Report

    Thanks,

    Arthur.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 01, 2016 at 11:34 AM

    Can you please share the screenshots or what are the conditions in first crosstab and second one?

    Ideally you can store the results in variable from first crosstab and use in other ones.If there is filter in second or third cross tab which are different then you can use nofilter function on variable to bypass the filters.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2016 at 02:32 PM

    Amit,

    Attached is the screen shot. I would like the value of Revenue (I use breaks in this table to create a single column with Fold/Unfold) to be available in a variable so I can use it in other tables within the same report.crosstab.png


    crosstab.png (26.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2016 at 03:37 PM

    Amit,

    Thank you for looking into this. I found a way to get this done. I create a calculated measure in my Hana model and brought it to the universe as a measure. With in the report I declared a variable and with the context of In Report and it worked fine. But if you know how it could be done with out doing what I have done that would be great to know.

    Basically I have to create a variable of some kind to store the summarized value form one cross tab, then use that value else where in the report without getting affected by the context..

    Thank you,

    Arthur.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.