InputField in Pivot to change overall Avg.

[ajaysingh29]

Hi All,

I wanted to make one filed in Pivot as Input filed to change overall Avg . If I enter any new value in avg filed it should change total Avg.

How to achieve this? I have attached test Qvw.

Thank you for your help.

[sunny_talwar]

Where are you hoping to input a new value? I am not sure I understand the requirement completely

[dsharmaqv]

you can try like this

But input field works only with table box not with pivot table.

INPUTFIELD Field3;
INPUTFIELD Field4;
LOAD Month,
Field1,
Field2,
Field3,
Field4,
F
FROM

(ooxml, embedded labels, table is Sheet1);

[ajaysingh29]

Hi Sunny,

Highlighted is the required Input values.

If I change any value there it should change overall AVG (93) accordingly.

[ajaysingh29]

Hi Deepak,

Thank you for your reply.

However, I cant make those filed as input as per required solution. Just wanted to validate if I change AVG of particular value how it will impact on Overall Avg. Is it possible ?

That's fine if its not Pivot. Can I use Straight table instead table box for Input filed? 

[dsharmaqv]

Input field will work only with table box not with charts

Yes it will impact overall Avg as well on-fly.

also add row num as row id.

INPUTFIELD Field3;
INPUTFIELD Field4;
LOAD rowno() as ID,

Month,
Field1,
Field2,
Field3,
Field4,
F
FROM

(ooxml, embedded labels, table is Sheet1);

[vinieme12]

I think you want to do What-IF analysis

Search the community for other related posts for more ideas

What If analysis.doc

[ajaysingh29]

  Deepak,

can’t make field3 & 4 as Input field. Those fields contain spend related amt.

My requirement is If I change Avg for particular vendor (suppose A which is in Field1 is vendor), how that will impact on overall avg of all the vendors.

 

Hope this will give you some more clarity about requirement. 

  Thank you for your efforts & help. 

[ajaysingh29]

Thank you Vineeth. I will check the document.

[dsharmaqv]

Since AVG is a calculated expression. The work arround I can see is to perform you calculation at the load script and then define that field as input field.