Need help in Pivot Table

[krishna20]

Hi Folks,

I'm facing an issue calculating metrics in pivot table. I'm having a metric for example SUM(SOHMAX), however user still have an option to choose either base from SSOHMIN or SOHMIN values. It should shown in single column. Is it possible??

Please find the attached sample doc and guide me.

Regards

Krishna

[PradeepReddy · Accepted solution]

if you are able to reload the application, try my solution as suggested earlier.. it will work..

you need to do small workaround in your application.

1. Create a data island with field values (MM_SOHMAX,MM_SOHMIN,MM_SSOHMIN,APPRSOH) and Name the column as Measure.

2. Reload the application

3. Create a list box with field 'Measure' and choose the option always one selected value.

4. In Pivot Table, add an expression sum(APPRSOH-$(=GetFieldSelections(Measure)))

See the attachment...

[krishna20]

Thank you Pradeep, I will try and let u know...

[krishna20]

Hi Pradeep,

I'm having many Items and Item_ Description following with Location field. How can i include in Inline Table all these stuff?? Please look into my sample app.Please guide me further.

[PradeepReddy]

no need of all those stuff in data island.. it will calculate based on the dimensions..

Did u tried this approach in your application? If yes, what is the issue you are facing?

[krishna20]

But, I need to give any ID right that data belongs to??

[krishna20]

Can you please provide your Personal email ID or contact??

[PradeepReddy]

u can reach me @ 8977957958