Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using TOTAL function in dril down chart.
When I am showing data in front then its totaling with respect to fields, but when I am drilling chart then its showing same total.
At the result of drill I wants separate values, but when I am using TOTAL function its only showing total values.
kindly Suggest
Below is the example:
Here its calculating A/total (B)
Expression:
sum({<Year={'$(vMaxYear)'},MATKL={'CM*'},[Work Center Sub Group]={'Rotary Furnace'},[Segment Final]={'Lead'}>}Quantity_MSEG_FlagConsumption2)/
Sum(total<[Plant Name]>{<Year={'$(vMaxYear)'},BWART1={'101_102'},[Work Center Sub Group]={'Rotary Furnace'},[Segment Final]={'Lead'},[Material Name]>}Quantity_MSEG)
Material Name | A/B |
---|---|
31.17 | |
Used Oil | 31.17 |
But when I am using used oil then its also showing same value (31.17), but I wants to select respected values.
By your output , there is only one value when oil is there I think that is why it is showing same value, if not give a sample example if possible
Are you using a Drill Down group here?
May be try like this
Sum({<Year={'$(vMaxYear)'},MATKL={'CM*'},[Work Center Sub Group]={'Rotary Furnace'},[Segment Final]={'Lead'}>}Quantity_MSEG_FlagConsumption2)/
Sum(TOTAL <$(='[' & GetCurrentField([DrillDownGroup]) & ']')> {<Year={'$(vMaxYear)'},BWART1={'101_102'},[Work Center Sub Group]={'Rotary Furnace'},[Segment Final]={'Lead'},[Material Name]>}Quantity_MSEG)
Hi Sunny,
Your formula is not working. I think I have to use this type of function, but it is not right.
Kindly check..
What is the name of your DrillDownGroup?
Now I am only using one filed which name is PLANT.
Please write correct syntax.
Helping sunny, rakesh in the chart you might be using a drilldown group as dimension, what is the name of that, that what sunny is asking
But you mentioned Drill Down chart? What is a drill down chart
Please write correct syntax.
I cannot write the correct syntax unless I know what you are trying to do. I suggest you provide more details or a sample so that we can help you out.
Best,
Sunny
=count(total <DrilldownDim1, DrilldownDim2, DrilldownDim3,,,DrilldownDimn> CREST_SERIAL_NO)
Hi Sunny,
This is first seen:
As per my expression, A/B= Consumable/Production Qty = 797042 / 25570=31.171
But when I am selecting Used Oil in chart, then its showing same 31.171 value.
It has to show 6579 / 25570=.25