Forum Discussion
Solved
CALCULATE PERCENTAGE
Hi I have created a matrix table in the following manner branch product spares % chennai 10000 500 ? ? I want to create the perc...
Hi srkase
Try this.
% of Spares = VAR _products = CALCULATE( SUM( YourTable[TOTAL QTY] ), YourTable[CATEGORY] = "PRODUCT" ) VAR _spares = CALCULATE( SUM( YourTable[TOTAL QTY] ), YourTable[CATEGORY] = "SPARES" ) RETURN DIVIDE( _spares, _products )Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
how to send the sample to you?
Hi srkase
You can create a sample table in excel and paste it here.
Best Regards,
Mariusz
Please feel free to connect with me.
Mariusz
Please feel free to connect with me.
YEAR SHORTNAME DEALER TYPE MAJOR GROUP MINOR GROUP SUB GROUP PRODUCT VARIANT APR MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR TOTAL QTY TOTALVAL PTA_DESTINATION UNIT_CODE PTA_DISTRICT PTA_TALUK PTA_PIN ACP_ENTRYDT HP PER APR VAL MAY VAL JUN VAL JUL VAL AUG VAL SEP VAL OCT VAL NOV VAL DEC VAL JAN VAL FEB VAL MAR VAL TOTAL CR DLR NAME_DEST DEST_DST_PIN DST_DEST_PIN PIN_DEST_DST CATEGORY 20172018 TCR 4 STD SUBMERSIBLES 6" SET EMS+ESRS EMS7MS + ESRS31-23 33AAA + 13FAA 1 0 0 0 0 0 0 0 0 0 0 0 1 15000 VADAKKENCHERRY ASE1 PALAKKAD ALATHUR 678683 ######## 7.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CHANS ELECTRICALS VADAKKENCHERRY VADAKKENCHERRY PALAKKAD 678683 PALAKKAD VADAKKENCHERRY 678683 678683VADAKKENCHERRY PALAKKAD PRODUCT 20172018 TCR 5 STD SUBMERSIBLES 6" SET EMS+ESRS EMS5MS + ESRS31-15 33AAA + 13FAA 1 0 0 0 0 0 0 0 0 0 0 0 1 15000 SULTHAN BATHERY ASE1 WAYANAD SULTHANBATHERY 673592 ######## 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 GRANPA MARKETING CORPORATION SULTHAN BATHERY SULTHAN BATHERY WAYANAD 673592 WAYANAD SULTHAN BATHERY 673592 673592SULTHAN BATHERY WAYANAD PRODUCT 20182019 TCR 6 STD SUBMERSIBLES 6" SET EMS+ESRS EMS7MS + ESRS51-08 33AAA + 13FAA 1 0 0 0 0 0 0 0 0 0 0 0 1 15000 KOZHINJAMPARA ASE1 PALAKKAD CHITTUR 678555 ######## 7.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 VISHNU ELECTRICALS KOZHINJAMPARA KOZHINJAMPARA PALAKKAD 678555 PALAKKAD KOZHINJAMPARA 678555 678555KOZHINJAMPARA PALAKKAD PRODUCT 20192020 TCR 8 STD SUBMERSIBLES 6" SET EMS+ESRS EMS5MS + ESRS42-10 33AAA + 13FAA 1 0 0 0 0 0 0 0 0 0 0 0 1 15000 VADAKKENCHERRY ASE1 PALAKKAD ALATHUR 678683 ######## 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CHANS ELECTRICALS VADAKKENCHERRY VADAKKENCHERRY PALAKKAD 678683 PALAKKAD VADAKKENCHERRY 678683 678683 VADAKKENCHERRY PALAKKAD PRODUCT 20192020 TCR 9 STD SUBMERSIBLES 6" SET EMS+ESRS EMS5MS + ESRS36-12 33AAA + 13FAA 1 0 0 0 0 0 0 0 0 0 0 0 1 15000 PAZHAYANNUR ASE1 THRISSUR THALAPILLY 680587 ######## 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 GUARANTY PUMPS & BOREWELLS PAZHAYANNUR PAZHAYANNUR THRISSUR 680587 THRISSUR PAZHAYANNUR 680587 680587 PAZHAYANNUR THRISSUR PRODUCT 20182019 TCR 10 STD SUBMERSIBLES 6" SET ST+RS-S ST075D + RS31SS/30 31AAA + 21FAA 1 0 0 0 0 0 0 0 0 0 0 0 1 15000 KOTTAYAM ASE1 KOTTAYAM KOTTAYAM 686001 ######## 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 KOTTAYAM MOTOR HOUSE KOTTAYAM KOTTAYAM KOTTAYAM 686001 KOTTAYAM KOTTAYAM 686001 686001KOTTAYAM KOTTAYAM PRODUCT 20172018 TCR 15 STD SPARES SPARES SPARES IMPELLER HCS725H / ASMSP725H (SS) (SP) 0 0 0 0 0 0 0 0 5 0 0 0 5 1900 SULTHAN BATHERY ASE2 WAYANAD SULTHANBATHERY 673592 ######## 0 0 0 0 0 0 0 0 0 0 0 0 0 0 GRANPA MARKETING CORPORATION SULTHAN BATHERY SULTHAN BATHERY WAYANAD 673592 WAYANAD SULTHAN BATHERY 673592 673592 SULTHAN BATHERY WAYANAD SPARES 20172018 TCR 16 STD SPARES SPARES SPARES IMP+DIFF ASSY JRF06 (SPS) 0 0 0 0 0 0 0 0 45 0 0 0 45 2000 MANANTHAVADY ASE4 WAYANAD MANANTHAVADY 670645 ######## 0 0 0 0 0 0 0 0 0 0 0 0 0 0 KUZHIKANDATHIL PLUMPING&ELECTRICALS MANANTHAVADY MANANTHAVADY WAYANAD 670645 WAYANAD MANANTHAVADY 670645 670645 MANANTHAVADY WAYANAD SPARES 20172018 TCR 17 STD SPARES SPARES SPARES IMP+DIFF ASSY JRF09 (SPS) 0 0 0 0 0 0 0 0 45 0 0 0 45 2100 MANANTHAVADY ASE4 WAYANAD MANANTHAVADY 670645 ######## 0 0 0 0 0 0 0 0 0 0 0 0 0 0 KUZHIKANDATHIL PLUMPING&ELECTRICALS MANANTHAVADY MANANTHAVADY WAYANAD 670645 WAYANAD MANANTHAVADY 670645 670645 MANANTHAVADY WAYANAD SPARES 20182019 TCR 19 STD SPARES SPARES SPARES DIFFUSER HOUSING RS30/35/40 (SPS) 0 0 0 0 0 0 0 0 12 0 0 0 12 2300 KOTTAYAM ASE1 KOTTAYAM KOTTAYAM 686001 ######## 0 0 0 0 0 0 0 0 0 0 0 0 0 0 KOTTAYAM MOTOR HOUSE KOTTAYAM KOTTAYAM KOTTAYAM 686001 KOTTAYAM KOTTAYAM 686001 686001 KOTTAYAM KOTTAYAM SPARES 20182019 TCR 20 STD SPARES SPARES SPARES PAN HEAD SCREW MS M5 X 16 MM (SP) 0 0 0 0 0 0 0 0 100 0 0 0 100 2400 QUILANDY ASE2 KOZHIKODE KOYILANDI 673305 ######## 0 0 0 0 0 0 0 0 0 0 0 0 0 0 COSMOS ELECTRICALS QUILANDY QUILANDY KOZHIKODE 673305 KOZHIKODE QUILANDY 673305 673305 QUILANDY KOZHIKODE SPARES