Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count values from multiple fields

Dear Experts, I want to count values in multiple fields as shown in below image -   I want result like below -   Entry Planted Name No of Count P3550 4 M2020 11 M2011 8 ...
  • Sujit_Thakur's avatar
    Sujit_Thakur
    5 years ago

    Dear @bhuprakashs

    I have your problem solved, here it is,

    But let me mention, you'll need an index table, so that you can relate it to the unpivoted column called as values.
    So that counting values other than the index to add in the rows field.

    I hope this solves your problem.

    I expect a "like in both of my post", will motivate me to help more friends like you.
    and if this post brought answers to your questions please accept this post as a solution

    If there are further doubts please let me know.

    Best regards

    Thakur Sujit

  • Sujit_Thakur's avatar
    Sujit_Thakur
    5 years ago

    Dear @bhuprakashs ,
    happy to know , if you have any doubt you can always ask ,
    just drop me a message here in community message box ,
    ill be happy to help.

    Regards
    Sujit Thakur

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
5 years ago

Dear Anonymous ,
I got your question 
https://drive.google.com/file/d/1msJ8bR2IuJfercsDW6D3etuQ70OjHvJZ/view?usp=sharing


go to this link download , it is yur solutiuon 

steps are 
1) You must have a index table with Distinct name 
2)  go in transform data , using home option in your Head ribbon , after going in transform , you will see your table
3)Now select all columns you want to count , then go in transform tab click unpivot selected columns 


3)Then close and apply .

4) Make sure your name from index has relation with values after unpivoting .(using model ribbon on LHS)

5) then just put


Done !!!



Please dont forget to give kudos ,
If it help you reach your solution please accept this post as solution .
if any further doubt please let me know ill be more than happy to help

Thanks 
Sujit 

  • Sujit_Thakur's avatar
    Sujit_Thakur
    Solution Sage
    5 years ago

    Dear @bhuprakashs

    I have your problem solved, here it is,

    But let me mention, you'll need an index table, so that you can relate it to the unpivoted column called as values.
    So that counting values other than the index to add in the rows field.

    I hope this solves your problem.

    I expect a "like in both of my post", will motivate me to help more friends like you.
    and if this post brought answers to your questions please accept this post as a solution

    If there are further doubts please let me know.

    Best regards

    Thakur Sujit

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you @Sujit_Thakur for your help.

      I have done it. I just did unpivoting and then grouped it and it solved my problem.

      Thank you all once again 🙂

      • Sujit_Thakur's avatar
        Sujit_Thakur
        Solution Sage
        5 years ago

        Dear @bhuprakashs ,
        happy to know , if you have any doubt you can always ask ,
        just drop me a message here in community message box ,
        ill be happy to help.

        Regards
        Sujit Thakur