Forum Discussion

anoomohan's avatar
anoomohan
Helper III
2 years ago

Need Help

hi all,   I need to create one powerbi report from an excel with columns for 2023 sales, 2024 target, salesman before and salesman after transfer.    The report structure shd be like below with b...
Need Help
anoomohan's avatar
anoomohan
Helper III
2 years ago

above is the data ; i am currently making 2 pivot in excel and then copy pasting manually in below format

 

FINAL OUTPUT IN REPORT NEEDED        
SM NAMEJAN 2023 BEFOREJAN 2024 AFTERJAN 2023 AFTER TRANSFERJAN 2024 AFTER TRANSFERFEB 2023 BEFOREFEB 2024 AFTERFEB 2023 AFTER TRANSFERFEB 2024 AFTER TRANSFER 
JOHN MATHEW3,6425,20714,74818,271     
KEVIN THOMAS1,9375,967 792     
MATHEW PERRY14,74815,801 7,896     
SHAUN RONALD31,72836,9624,4756,431     
TIM BRAT15,8409,7863,6425,207     
VARUN VARMA4,4756,43133,66539,667     
VIVEK SHARMA 7,89615,8409,786     
Grand Total72,37088,05072,37088,050