Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have the data where it mention as, i want to prepare a pivot table where dimension will be my design no with out Hyphen.
DESIGN_NO | SALES QTY |
1425895-EE | 1 |
14532861-FD | 2 |
58462879999-FF | 5 |
1425895-EF | 4 |
1425895-EG | 8 |
1425895-DD | 9 |
14532861-FF | 10 |
58462879999-FA | 1 |
How to get the data without hyphen,
After Removing of Hyphen,
Row Labels | Sum of SALES QTY |
1425895 | 22 |
14532861 | 12 |
58462879999 | 6 |
Grand Total | 40 |
You could use it in both the front end and script level ...Script end is the most preferred one
You can try this
On UI you can do
Dimension :- Subfield( DESIGN_NO,'-',1 )
Expression:- Sum( [SALES QTY] )
On Load Script
Load
Subfield( DESIGN_NO,'-',1 ) as DESIGN_NO,
[SALES QTY]
From Location;