Skip to Content

Percentage caluculation of sales using the from and to qtr prompts from bex query.

Hi Experts ,

we are getting the data to the Webi report from bex query where we are to mandatory Prompts as Financial Qtr (from) and Financial Qtr(To) for the financial Qtr object.

To calculate the % of sales quarter wise we are using the formula as (sales of respective Qtr -Previous Qtr Sales) /Previous Qtr sales.


So to get the Previous Qtr sales we asked BI team when ever user selects the from Qtr prompt provide the sales values from the previous Qtr.

ex: From : 2010.3 to 2011.1


then the bex query will provide the sales as


financial Qtr Sales

2010.2 100

2010.3 150

2010.4 200

2011.1 250.


with this I am able to calculate the % sales but for one cross table in the same report


I need to display the sales as qtr wise


So when I Drag n Drop the Financial Qtr, Sales

it wil display the values as

financial Qtr sales

2010.2 100

2010.3 150

2010.4 200

2011.1 250.

So How to avoid displaying of the previous qtr value of the financial Qtr Dimention for this Table

Please Help Me .... Urgent.....

Thanks

Regards

Nikil

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 02, 2015 at 06:39 PM

    Create a variable v_flag in the report with the below formula.

    =If([financial Qtr ]=Min([financial Qtr ]) ForAll ([financial Qtr ])) Then "Y" Else "N"

    Then apply a filter to the table with the condition v_flag =N

    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.