Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart for money used vs forecasted money. I want it to be stacked with the money used split between labor and shopwork $. and then the forecast by itself. I am able to do this but I need it sorted by month. However, I do not have a month field. The data I pull is from a binary file with $Jan, $Feb, etc... as all separate fields. How would I be able to sort this by month with no month field? I do not believe that I can crosstable them since it is from a binary file.
e.g.
Table: Load * Inline [ ID, Feb, Mar 1, A, 2, B, C 3, , D ]; Table2: CrossTable(Month, Data) LOAD ID as Iden, Feb, Mar Resident Table;
result