Drill in TOTAL function

[rkspareek1992]

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.

[kkkumar82]

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

[sunny_talwar]

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)

[rkspareek1992]

Hi Sunny,

Your formula is not working. I think I have to use this type of function, but it is not right.

Kindly check..

[sunny_talwar]

What is the name of your DrillDownGroup?

[rkspareek1992]

Now I am only using one filed which name is PLANT.

Please write correct syntax.

[kkkumar82]

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

[sunny_talwar]

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

[sarvesh]

=count(total <DrilldownDim1, DrilldownDim2, DrilldownDim3,,,DrilldownDimn> CREST_SERIAL_NO)

[rkspareek1992]

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