• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

pivot table based on suitable input filter and auto calculation in data

L

linga

New Member
Dear all,

I am linga , new to this forum , sample data is attached for reference and the detailed

logic is explained inside. Pivot table data needs to be calculated based on data when I choose the respective plant in pivot table.
 

Attachments

Didn't figure out this...

Pls explain.

Then Sum the % to total , when the valuereaches to 80 Put Those entries as A,
when the valuereaches to 95 Put Those entries as B,remainig rows as C.
 
hi,

Thanks for reply. Pl refer below comments.

Then Sum(Add the values one by one) in % to total Column, when the value reaches to <=80.00 Put Those entries as A,
when the value reaches to>=80.01 & <= 95.00 Put Those entries as B,Then >=95.01 & <=100remaining rows as C. Pass In ABC Column.

ex:19000/28880=65.79

Then sum 65.79+6.54+6.20=78.5 which is <=80.00

Regards,

Linga

 
Hi:

As Deepak indicated your logic behind assigning ,"A","B" or "C" is not making any sense. On what basis your are deciding on adding 65.79+6.54+6.20, is it based on some plant ID? You should be bit more elaborate on your explanation.

Thanks
 
Hi,

It is based on Plant ID & Category ex: XXXX-DM ,XXXX-IDM ,Where I am identifying what are all the materials falls Under "A" Category , B category and similarly C category. based on the logic explained. When I choose Multiple plant as Input In Pivot filter Same logic needs to be computed for multiple plants.



Regards,

Linga
 
Last edited:
Hi:

I have set up formulas in sheet1 from in range G212:G271 and I212:I271, I have try to replicate the logic you had explained in that sheet. Manually do the math and compare it with formula results to find out whether the formula is working as per your need. The sorting instruction I have given is important for the formula to work. If the logic seems to be fine , you can pull a pivot from the table. Note I am not fully clear abt your categorization into "A","B" & "C", I have used the logic as per my understanding you can tweak it as per your need.Let me know with questions if any.

Thanks
 

Attachments

You must log in or register to reply here.
Back
Top