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

Thanks

Regards

Nikil

10|10000 characters needed characters exceeded

Related questions

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