Is it possible to create the following type of crosstab report?
Company(C1,C2,C3)
ABC,Atlantic,0.75
XYZ,Central,0.50
Product(P1,P2,P3)
Small Nut,5mm,1.00
Small Bolt,7mm,2.00
Details(D1,D2,D3)
ABC,Small Nut,500
ABC,Small Bolt,350
XYZ,Small Nut,750
P1
P2 P3
------
C1 C2 C3 | D3 D4(D3*P3*C3)
Small Nut Small Bolt
5mm 1.00 7mm 2.00
------------ ------------
ABC Atlantic 0.75 | 500 375.00 350 525.00
XYZ Central 0.50 | 750 562.50
------------ ------------
1250 937.50 350 525.00
Crosstab report
Crosstab report
- Attachments
-
- 1279.crosstab.png (11.92 KiB) Viewed 1209 times
Crosstab report
Hello.
Yes, it is possible. Please, see the attached report template.
Thank you.
Yes, it is possible. Please, see the attached report template.
Thank you.
- Attachments
-
- 1283.Report.mrt
- (16.37 KiB) Downloaded 244 times
-
- 1281.data.xml
- (648 Bytes) Downloaded 212 times
Crosstab report
Thank you! I am pretty sure I can work with this.
Crosstab report
Great!