If you want to combine two fields then try & or + sign as per your requirement.
Month&'-'&Year as MnYr
Concatenation is an operation that uses two tables and combines them into one. refer Help:
Load * from file1.csv;
load * from file2.csv;
.. .. ..
Concatenate (tab1) load * from file3.csv;
Can you help me i have a question, how can i add a column in a pivot table chart, for example:
i have this pivot table:
Enterprise Value Value2 Value3
AAA 1 2 3
BBB 1 2 3
CCC 1 2 3
i need to put a new column with the sum of the rows, can you tell me how to do it?
Enterprise Value Value2 Value3 Total
AAA 1 2 3 6
BBB 1 2 3 6
CCC 1 2 3 6