Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
5 years ago

Calculate or get values from a different table

Hi,   What I need in somehow an idea on how to get the following OUTPUT table that you see in the screenshot. The problem is that I have all my data in "ApproveSubmit" table but also I need the col...
General Comment
Need Help
Tips and Tricks
cristianml's avatar
cristianml
Post Prodigy
5 years ago

Hi Anonymous ,

 

I also tried but doesn't work cause the value from ApproveSubmit tab is being duplicated due to have multiple SG % in Map table for each contract. What I need is, with a Slicer by SG over a Pivot table, that can show me the Value from ApproveSubmit but with the correspoding SG % portion.

 

Example of this :

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi cristianml ,

 

1.Merge two tables

2.Expand the table

3.Create two custom columns

4.Remove the unwanted columns and rename the custom columns.

 

More details you can check the attachment.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • cristianml's avatar
    cristianml
    Post Prodigy
    5 years ago

    Hi Anonymous ,

    The thing is that the first table has the categories (Revenue,CI etc) in 1 column instead of split  in columns: