Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Can some one help me to get the below row data into columns as in the picture. i have tried using the Pivot. its not working for multiple columns for the same total.
Data Sample:1
Pivot in excel:
Data For working:
ID | Name | SL | SSL | Revenue |
101 | XYZ | Advisory | PAS. | - |
101 | XYZ | Assurance | Audit | 21,657 |
101 | XYZ | Assurance | FAAS | - |
101 | XYZ | CBS & Elim | ITTS (Elim) | 163,993 |
101 | XYZ | CBS & Elim | PAS (Elim) | - |
101 | XYZ | TAS | Corporate Finance | 75 |
101 | XYZ | TAS | ITTS (in TAS) | - 163,993 |
101 | XYZ | TAS | Strategy and Operations | - |
101 | XYZ | TAS | TD - Transaction Diligence | 12,806 |
101 | XYZ | Tax | BTS | 11,227 |
101 | XYZ | Tax | GCR | 11,904 |
101 | XYZ | Tax | Indirect | 13,013 |
101 | XYZ | Tax | International Tax Transaction Services | - 163,993 |
101 | XYZ | Tax | PAS | - |
1011 | ABC | Advisory | PAS. | 12,506 |
1011 | ABC | CBS & Elim | ITTS (Elim) | - 1,998 |
1011 | ABC | CBS & Elim | PAS (Elim) | - 12,506 |
1011 | ABC | TAS | ITTS (in TAS) | 1,998 |
1011 | ABC | Tax | GCR | 36,497 |
1011 | ABC | Tax | Indirect | 4,477 |
1011 | ABC | Tax | International Tax Transaction Services | 1,998 |
1011 | ABC | Tax | PAS | 12,506 |
Hi @RanjanThammaiah ,
Matrix is a best choice as suggested by @mussaenda ,have you tried it?Is your issue solved?
Hello @RanjanThammaiah
Not sure what you are trying to achieve. Are you trying to transform the data table into the displayed pivot table structure (with two-row headers, minus the total)?
Regards,
Vivek
https://www.vivran.in/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |