Top N Product items Gross Sales as percentage of column

10-11  Source: Network gathering  Views:1 

Advertisement
Hi everyone,
I'm using OBIEE 11.1.1.6.2.
I want to show in a pivot table Top N Product Gross Sales by Market as percentage of columns (N is a presentation variable of a variable prompt) .
Below an example of OBIEE wrong behaviour and the expected one:
-All Products:
Market: UK, N = 15
Product % Gross Sales
A 18,4%
B 15,3%
C 9,0%
D 5,0%
- Top 2 Products (OBIEE wrong behaviour)
Market: UK, N = 2
Product % Gross Sales
A 54,5%
B 45,5%
- Top 2 Products (expected correct behaviour)
Market: UK, N = 2
Product % Gross Sales
A 18,4%
B 15,3%
How can i get the correct behaviour?
Thanks
Edited by: user8816444 on 9-ott-2012 7.50
Make sure your config is similar as below
Your promot colum suppose to be as below, to pass the number to report
SELECT TOPN("%sales",15) FROM SubjactArea order by Product
In your report you should have column with expression
TOPN("%Sales", cast(@{N}{2} as int))
Pls mark correct/helpful if helps
Related articles
  • Top N Product items Gross Sales as percentage of column 10-11

    Hi everyone, I'm using OBIEE 11.1.1.6.2. I want to show in a pivot table Top N Product Gross Sales by Market as percentage of columns (N is a presentation variable of a variable prompt) . Below an example of OBIEE wrong behaviour and the expected one

  • How to get top 10 sales amount percentage over all sales amount 11-30

    Hi All, I need to generate a table/pivot table to pick FY13 top 10 sales amount by product (say P1, P2, P3, P4, etc), these top 10 total amount, percentage over total sales, comparing these top 10 in FY12 total sales amount, and percentage over total

  • Production order from sales order with multiple line item(for one material) 10-11

    Dear Gurus, I am working in MTO scenarios. If there is several line item in a sales order for one material, multiple production order( same as no. of sales order line item) is getting created against each of the line item.My requirement is,since the

  • Preli cost compo struc of production orders to sales orders -Non valuated 10-11

    Hi experts We use Non valuated sales order cost/settlement and assembly order processing. So production order is created from sales order and prel cost estimate is created in the production order. Now we notice that the cost component struc in produc

  • Different product hierarchy in sales order and in service order 10-11

    Dear experts, In VA03, I notice that - under Line Item > Sales B, there is a field Product Hierarchy - under Line Item > Account assignment, there is a field Order. From here, it links to a service order. In the service order, I can see a field Prod

  • Product cost by sales order cost analysis 10-11

    hi exports, my client want a  in customization  report sales order line item wise  sales order number , item,sales order value, production order number, material number, orderactual material cost, actual activity cost and actual oh, how to prepare fu

  • Automatically add line-items to Sales order 10-11

    Hello, Our client needs us to add line items to sales orders. The requirement is such that, when the users enter a material on a line item, they wish to see few more materials automatically added as new line items -- item category to be maintained as

  • Production Variance to sales order... 11-30

    Hi Experts, It is possible to settele Production Variance to sales order item(MTO with valuted sales order). The production order is created with reference to sales order.... Please someone tell me how can settele variance to sales order to view the

  • Difference between Gross sales Proceeds and Receivables 11-30

    Hi Can anyone advise diff between gross sales proceeds and Receivables in A/R. Is gross sales proceeds is subset of Receivables? Many Thanks.<b>Gross proceeds of sales</b>" means the value proceeding or accruing from the sale of goods and

  • Gross sales proceeds 11-30

    Hi Friends, I'm testing a BW report, which has gross sales proceeds. I need to test the values of gross sales proceeds in the BW report against R/3. Can any one please let me know what trans action(s) should i look into and and what considerations i

  • Change the ITEM PER SALES UNIT 11-30

    Hi experts. I try to change the value in Items per sales unit, but the system give me an error 'CAN NOT BE CHANGED TO AN ITEM WITH TRANSACTION. Now we plan for the next month to change the package for abaout 2500 products that we produced. Someone ca

  • Show the top n products 11-30

    hello:      i have ten products, now i have calculated the percentage of the ten products, i want to show the top three products percetage,and the other seven is proposed to be showed as 'others' in total. for example:        company code           

  • Product Costs by Sales Order - Settlement Options? 11-30

    Hello All - I am trying to understand if I need to settle to a sales order (SDI) or directly to material (MAT) or to COPA (PSG). If i look at my sales order, it has item category ZPSF, which product costs by sales order configuration shows a requirem

  • Business Content for Product Cost by Sales Order 11-30

    Hi, We need to do reporting on costs associated to Sales Orders. The corresponding R/3 Area is "Product Cost by Sales Order" in Cost Object Controlling. We have looked at the standard cube for Cost Object Controlling (0PC_C01) but this cube only

  • MTO-Product cost by Sales Order 11-30

    Hi Guys, My client is manufacturing Energy Meters, they want Sales order based Production Planning and costing etc., in MTO scenario, Product cost by Sales Order 1. Sales Order will be created 2. BOM is created 3. some of raw material in the BOM list

  • Product cost by sales order - conceptual clarity required 11-30

    Hi, We are a manufacturing company with both Make to Stock and Make to Order Scenarios. In cost object controlling, we have made the settings for product cost by order. Now, the question is whether product cost by sales order is a mandatory setting i

  • Product costing by sale order 11-30

    Dear all, Please tell me the process in product costing by sales order. In my client place, i have done the configuration but i dont know the process. Please guide me. Thanks & Regards, ARHi, Product cost by sales order is useful when  a finished pro

  • Product costing by sale order(urgent) 11-30

    Dear all, 1. Please tell me all the configuration steps to do product costing by sale order. 2. Also please tell me how to test it after configuring. 3. Please explain me the end user part also. I will award full points. Thanks & Regards, A.Anandaraj

  • Report for daily production and daily sales 10-11

    Can you any body Please let me know which fields we should pick to create custom report containing production  qty and sales qty day wise for each materialHi Veesh, Whats the scenario you using there? i mean to ask Discrete REM or PP-PI Thanks & Rega

  • Partial delivery per item in sales order and ATP - schedule lines 10-11

    Hi, I've problem regarding ATP- schedule lines and partial delivery flag. In sales order there is flag Partial delivery per item B / 1 . That means create only one delivery even with quant 0. That comes from customer master or customer info-record an