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

[krishna20]

Hi Thank you,

I Think this idea may works.Can you make it as sample file for me??

[asgardd2]

Sample with two buttons.

[krishna20]

You Mentioned

You want see sum of two values in expression?

No, I should not sum two values at a time. I need to show SUM(MM_SOHMAX) as default.

User can see what is the value for SUM(MM_SOHMIN) or SUM(MM_SSOHMIN).

How can a user select other metrics in the same expression, when we are using single expression to show??

[krishna20]

Than you Anton for your inputs.

Sorry there is an lack of explanation from my side. Pardon me for that.

Let me clearly explain with an another example.

Having a Dimension and 4 Expressions in Pivot table. Like Sum( X), Sum(A), Sum(B), Sum(C).

I need to insert another column with an expression of Sum(A-X) by default.

If the user want to see what's the value for Sum(B-X) or Sum(C-X) in the same expression(The values B or C should replace when those selected) . How can it be done??

edited :

In X ->> APPROH

In A->>MM_SOHMAX

In B-->>MM_SOHMIN

In C->> MM_SSOHMIN

I hope its clear ..Please let me know if any inputs needed..

[PradeepReddy]

see the attachment..  might be helpful for you..

[krishna20]

Thank you pradeep for your valuable reply.

It's a nice approach. But, I'm having  three values here,

In A->>MM_SOHMAX

In B-->>MM_SOHMIN

In C->> MM_SSOHMIN which needs to subtract from X ->APPROH.

edit:

I'm applying your logic. But it's showing result as null.

=sum($(=GetFieldSelections(APPRSOH)))-sum($(=GetFieldSelections(MM_SOHMIN)))

Please, suggest me based on that..

[krishna20]

Showing unconcerned values when using

=sum($(=GetFieldSelections(APPRSOH)))-sum($(=GetFieldSelections(MM_SOHMIN)))

Subtraction is not working correctly.PFA

[PradeepReddy]

you need to create 2 data islands as shown in previous post... and apply the bellow logic...

sum($(=GetFieldSelections(APPRSOH))-$(=GetFieldSelections(MM_SOHMIN)))

still if u are not getting wt you are expected, share sample application..

[krishna20]

Hi Pradeep,

I have shared sample app in the start discussion of this thread . Please find it..

edit:

I cannot reload the application. I'm trying to achieve this in front end.

[krishna20]

Any Idea to achieve this in front end or in back end friends?? Please help me out..