Sum(Total) pivot table issue

[gr_eldred]

I need help with this operation

Sales / Total Sales

Example

W27 Sales / Total Sales

=num(

sum({$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>}  Cantidad_I)

/

sum( total {$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>}  Cantidad_I)

,'#,##0.00%')

can you help me Please!!

[petter]

Hi Eldred,

So what exactly is your problem? Doesn't it calculate the expression you showed us?

If you have some raw data or a sample application that would be very helpful to be able to get you feedback quickly...

[ogautier62]

Hi,

what does not work ?

have you got "expression OK" or not ,

what is your result ?

regards

[raviityou]

share sample .qvw and expected result.

[balabhaskarqlik]

In Pivot table, Do you want to calculate the Percentage of W27 on Totals?

[balabhaskarqlik]

Can it be:

=num(

sum({$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>}  Cantidad_I)

/

Aggr(NODISTINCT sum( total {$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>}  Cantidad_I), FieldName(art_Status))

,'#,##0.00%')

[neelamsaroha157 · Accepted solution]

=num(

sum({$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>}  Cantidad_I)

/

sum( total <Marca> {$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>}  Cantidad_I)

,'#,##0.00%')

[gr_eldred]

Is Correct Thank you very Much!! @Neelam Sehrawat

[neelamsaroha157]

I am glad it worked . Please close the thread.