Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a below table.
PH6 | PH6_desc | Sales T/O |
231546 | BV 546 | 1163729 |
255373 | VAG Produkte | 1092099 |
221051 | El. fusion fitti. PB | 880487 |
201950 | Solv.cement fitt.me. | 874874 |
230152 | Solv. Cement Fit. mm | 689215 |
202956 | Ballvalves for water | 550592 |
230153 | Adapter Fittings mm | 531082 |
251313 | ELGEF Plus saddles | 464251 |
221043 | Pipe PB in bars | 451753 |
2J1J54 | Regulierarmaturen | 432843 |
Further I want to add new column as below. Kindly help me in doing this.
PH6 | PH6_desc | Sales T/O | New Column | Description |
231546 | BV 546 | 1163729 | 1163729 | For the first row the value should be same as Sales T/O(1163729) |
255373 | VAG Produkte | 1092099 | 2255828 | Addition of 1st row and 2nd row of Sales T/O(1163729+1092099) |
221051 | El. fusion fitti. PB | 880487 | 3136315 | 880487+2255828 |
201950 | Solv.cement fitt.me. | 874874 | 4011189 | 874874+3136315 |
230152 | Solv. Cement Fit. mm | 689215 | 4700404 | 689215+4011189 |
202956 | Ballvalves for water | 550592 | 5250996 | 550592+4700404 |
230153 | Adapter Fittings mm | 531082 | 5782078 | 531082+5250996 |
251313 | ELGEF Plus saddles | 464251 | 6246329 | 464251+5782078 |
221043 | Pipe PB in bars | 451753 | 6698082 | 451753+6246329 |
2J1J54 | Regulierarmaturen | 432843 | 7130925 | 432843+6698082 |
Please share the actual sample data
This is the sample data..
PH-6 | PH-6 name | Sales T/O | Cumulative T/O |
231546 | BV 546 | 1,163,729 | 1,163,729 |
255373 | VAG Produkte | 1,092,099 | 2,255,828 |
221051 | El. fusion fitti. PB | 880,487 | 3,136,315 |
201950 | Solv.cement fitt.me. | 874,874 | 4,011,189 |
230152 | Solv. Cement Fit. mm | 689,215 | 4,700,404 |
202956 | Ballvalves for water | 550,592 | 5,250,996 |
230153 | Adapter Fittings mm | 531,082 | 5,782,077 |
251313 | ELGEF Plus saddles | 464,251 | 6,246,328 |
221043 | Pipe PB in bars | 451,753 | 6,698,081 |
2J1J54 | Regulierarmaturen | 432,843 | 7,130,924 |
251301 | PE Spigot Fittings | 393,140 | 7,524,064 |
229641 | Containit Pipe | 290,104 | 7,814,168 |
251314 | ELGEF Plus fittings | 248,483 | 8,062,651 |
281557 | customizing | 245,209 | 8,307,860 |
231161 | Contr.+ Check Valves | 240,762 | 8,548,623 |
234539 | KH 546 PP | 224,185 | 8,772,807 |
251312 | ELGEF Plus couplers | 216,383 | 8,989,190 |
230162 | Accessories | 210,783 | 9,199,973 |
234180 | Adapter Fittings mm | 176,652 | 9,376,625 |
339695 | ele.act.ballvalve546 | 171,343 | 9,547,969 |
201951 | adap.fitt.pipe M/Gas | 171,334 | 9,719,303 |
221050 | Socket fusion fi. PB | 161,197 | 9,880,500 |
231158 | Diaphragm Valves | 160,305 | 10,040,805 |
235188 | SYGEF pipes | 148,664 | 10,189,469 |
251303 | PE Saddles | 146,660 | 10,336,129 |
231567 | BV 567 PVC Wafer | 142,301 | 10,478,430 |
339212 | Diaphragm Valves | 142,195 | 10,620,625 |
281554 | Ventilation | 140,034 | 10,760,660 |
339696 | pne.act.ballvalve546 | 139,972 | 10,900,632 |
348227 | Variable Area Flow M | 138,327 | 11,038,958 |
235540 | KH 546 PVDF | 133,307 | 11,172,265 |
234238 | Flanges | 123,581 | 11,295,846 |
231149 | Ball Valves 353-355 | 123,476 | 11,419,323 |
339772 | MV DIASTAR | 116,451 | 11,535,774 |
228473 | Tangit | 110,817 | 11,646,592 |
232450 | Fittings CPVC | 109,420 | 11,756,011 |
263405 | Fittings NEW | 105,797 | 11,861,808 |
221039 | pipes d125-225 | 102,025 | 11,963,833 |
235190 | Butt Weld Fittings | 99,495 | 12,063,328 |
234403 | Butt fusion ad.unio. | 96,595 | 12,159,922 |
340220 | Sensors | 93,868 | 12,253,790 |
127140 | PRIMOFIT end load | 92,262 | 12,346,052 |
235191 | Adapter Fittings | 91,163 | 12,437,215 |
358458 | Products by Frank | 89,011 | 12,526,226 |
234179 | Butt Weld Fitting mm | 87,868 | 12,614,094 |
237202 | Pipes | 85,954 | 12,700,049 |
237773 | PVDFHP MV man | 78,989 | 12,779,038 |
231001 | BV 543 PVC | 77,636 | 12,856,674 |
230163 | Flanges PVC | 76,700 | 12,933,374 |
154323 | Couplings standard | 73,957 | 13,007,331 |
221061 | Valve PB | 72,306 | 13,079,636 |
280177 | Pipes PP | 72,178 | 13,151,814 |
339643 | Ele.actu. b.valve567 | 70,133 | 13,221,947 |
234637 | BV 567 PP-H Wafer | 69,749 | 13,291,696 |
265435 | Diaphragm Valve | 67,659 | 13,359,355 |
268241 | Butt ada.fitting ISO | 67,218 | 13,426,573 |
339215 | Solenoid valves | 63,427 | 13,490,000 |
280244 | Pipes PE100 | 61,885 | 13,551,885 |
231780 | PVCU MV man | 58,243 | 13,610,128 |
268240 | Butt weld fitting mm | 57,135 | 13,667,263 |
221045 | Carrier for pipe | 55,967 | 13,723,230 |
231156 | Ballval. 322-324,343 | 54,289 | 13,777,519 |
232541 | KH 546 C-PVC | 53,613 | 13,831,132 |
234178 | Socket Weld Fitt. mm | 49,917 | 13,881,049 |
339644 | Pne.act. b.valve 567 | 48,334 | 13,929,383 |
230166 | Adapter Fittings BS | 48,125 | 13,977,507 |
251306 | Electrofusion Units | 47,905 | 14,025,413 |
237249 | Butt Weld Fitting | 46,564 | 14,071,977 |
237230 | Unions | 45,057 | 14,117,033 |
280449 | Pipes PVC-C | 44,848 | 14,161,881 |
243770 | Machine IR 110 sales | 42,355 | 14,204,236 |
268332 | PEadapter fittingsMS | 39,214 | 14,243,451 |
346251 | Ele. Rotary Actuator | 38,523 | 14,281,974 |
226078 | PP HT-Syst.FittingIT | 33,959 | 14,315,933 |
340333 | Transmitter | 33,341 | 14,349,274 |
221600 | Butt fusi. d125-d225 | 32,589 | 14,381,863 |
268265 | Socket Weld Fittings | 32,220 | 14,414,083 |
234182 | Diaphragm Valves | 31,906 | 14,445,989 |
235421 | Butt fusion ada. un. | 31,263 | 14,477,252 |
235189 | Socket Weld Fittings | 30,994 | 14,508,246 |
234184 | Contr.+ Check Valves | 30,710 | 14,538,956 |
231798 | ac.gen.5ind.of subd. | 30,278 | 14,569,234 |
226077 | PP HT-System PipesIT | 29,480 | 14,598,713 |
251305 | Tools/Inst. Acc. | 28,947 | 14,627,661 |
233372 | Cool-Fit | 27,590 | 14,655,250 |
202958 | Ball valves for irr. | 27,405 | 14,682,655 |
228495 | Loctite | 26,135 | 14,708,790 |
235774 | PVDF DV514,515,517,519 | 26,087 | 14,734,877 |
339216 | Electric posit. ind. | 25,958 | 14,760,835 |
344232 | Sensors | 25,461 | 14,786,296 |
235784 | SYGEF Exhaust System | 25,101 | 14,811,396 |
215080 | Electr. control unit | 25,100 | 14,836,496 |
346248 | Pilot Solenoid Valve | 24,528 | 14,861,024 |
999999 | Dummy non-prod. | 24,429 | 14,885,453 |
237206 | Diaphragm Valve | 24,045 | 14,909,499 |
344334 | Transmitter | 23,541 | 14,933,040 |
339214 | Angle Seat Valves | 22,611 | 14,955,651 |
231160 | Angle Seat Valves | 22,073 | 14,977,723 |
237423 | Butt fusion ada. un. | 20,501 | 14,998,225 |
235193 | Diaphragm Valve Hand | 20,055 | 15,018,280 |
231155 | Ball Valves 346 | 18,732 | 15,037,012 |
233197 | Socket Fitti. mm ABS | 18,652 | 15,055,664 |
In your Table just sort the column you want to sort. For other column remove all the sort option (like for PH6,PH_desc) then I think original expression without aggr sorting option should work
Hi,
The above table is the combination of 2 to 3 tables and what ever i showed that is the final output i require..
I am asking to sort the field in front end chart and not in backend.
In chart properties->Sorting-> Sort only Sum(Sales T/0) expression. For rest uncheck all sort option
I tried, but no luck its not sorting
please share your qvf file
Please find the attached file
Hi Kush,
Thanks for the support, however we cannot derive the output as I needed.
Please go through the link below.
Yes. I got that. See the attached. with some tricks you can do that