suppose this is my data:
| PLACE | SHIP | STATUS | QUANTITY | tm |
| Load Port | shipment1 | 01 | 30,000.00 | 9.2 |
| Load Port | shipment2 | 01 | 30,000.00 | 8.7 |
| Load Port | shipment3 | 01 | 40,000.00 | 3.6 |
Discharge shipment1 01 100 1.5
Discharge shipment4 01 500 6.6
Discharge shipment5 01 400 4.5
Plant shipment1 01 1000 1.2
Plant shipment4 01 1000 5.3
Plant shipment6 01 1000 2.6
for that data i created two text boxs by writing these expressions
loadport
sum of quantity 100000(text box1)........exp1:=sum({<PLACE={'LOAD PORT'},SHIP_STATUS={1}>}TOTALQTY_DAILY)
TM 9.2(textbox2).......
.exp2=sum({<PLACE={'LOAD PORT'},SHIP_STATUS={1}>}QTY_DAILY*TM)/sum({<PLACE={'LOAD PORT'},SHIP_STATUS={1}>} QTY_DAILY)
i am trying to show breaks for each text box in a straight table i am showing the breakups for both quantity and tm
i am succeed in showing quantity breaks by adding all the dimension in straight table
Dimension:PLACE,SHIP,QUANTITY,TM
under quantity dimension :Enable conditional
if(GetSelectedCount(PLACE)>0,QTY_DAILY,0)
on textbox1:action--->select field---> field
place
value
loadport
over here i want to hide TM column when textbox 1 is clicked
in the same way
when i click textbox2: i need to show both QUANTITY AND TM column breakup values .........
