Here are the information.
We have one single Key Figure : COUNT(DISTINCT(“VBAK”.VBELN))
We have OLAP Table which tells how many SO are from Quotes and not from Quotes
Formula which we have for numbers are : COUNT_TABLE(“VBAK”) based on Quote selection where we have a case statement :
WHEN ISNULL(“VBAK”.“ZZQUOTATION_ID”) = 1 THEN ‘no Quote’
WHEN “VBAK”.“ZZQUOTATION_ID” = ‘’ THEN ‘no Quote’
ELSE ‘with Quote’ END
Now what we are looking for is another field which gives how many % of orders are coming from Quotes or non Quotes like
Formula which we are looking is : Orders coming from Quotes / Total number of Orders as % and vice versa. What is the
option to do this in OLAP table.