• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to make pivot on below condition
Dear All,

Please let me know how to solve this query i need to make pivot on attached file to find my data on Tentative & Final condition bases along with my TN,AR etc.
Also need all the details of my left hand side till balance stock.

Attached Files
.xlsx   Question File.xlsx (Size: 10.01 KB / Downloads: 15)
Can you also attach a sample output format you want to get?
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile

Related Topics
Topic Author Replies Views Last Post
  Hyperlink Hyperlink Pivot table data sanj_edu 0 762 14-Jun-2020, 06:37 PM
Last Post: sanj_edu
  Pivot Table Making Pivot table Jyoti 1 1,221 17-Feb-2020, 12:39 PM
Last Post: Vivekananda Sinha
  Pivot Table Pivot Table Query Lovedeep sharma 2 1,720 24-Sep-2019, 06:01 PM
Last Post: Anil Kumar Pal
  Pivot Table How to make dynamic two RAW switch in single Pivot Amitg9595 0 1,012 01-Jun-2019, 05:11 PM
Last Post: Amitg9595
  Others If & And Condition Anil Kumar Pal 4 2,136 21-May-2019, 02:50 PM
Last Post: Anil Kumar Pal
  Database Connectivity Need help to make database jeetsdec2009@gmail.com 1 1,388 27-Mar-2019, 03:15 PM
Last Post: Vivekananda Sinha
  Pivot Table Can we apply group in Pivot table Rinku Sharma 1 1,616 27-Jun-2018, 05:55 PM
Last Post: Vivekananda Sinha
  Pivot Table Range issue in pivot table Amit5210 3 2,624 30-May-2018, 03:38 PM
Last Post: Abhishek Jain
  Pivot Table Pivot Querry Shankardeep 1 1,565 22-May-2018, 05:02 PM
Last Post: Vivekananda Sinha
  Conditional Formatting Condition Formatting PRADEEP RASTOGI 3 2,518 20-Feb-2018, 10:12 PM
Last Post: sanj_edu
  Conditional Formatting Condition Formatting PRADEEP RASTOGI 1 1,930 11-Jan-2018, 08:54 PM
Last Post: sanj_edu
  Data Validation Drop Down with condition Dharmesh Kumar Srivastava 2 2,307 29-Dec-2017, 09:09 PM
Last Post: sanj_edu
Star Pivot Table Pivot Tables Sanjeev Singh 1 1,904 05-Nov-2017, 11:55 AM
Last Post: Mohit Sharma
  Conditional Formatting Count of duplicate value as single, on condition based Dharmesh Kumar Srivastava 1 2,103 18-Oct-2017, 04:04 PM
Last Post: Mohit Sharma
  Formula Condition based status update Dharmesh Kumar Srivastava 8 5,072 16-Oct-2017, 05:15 AM

Forum Jump:

Users browsing this topic: 1 Guest(s)