I have a piviot table, i would like to create a new piviot table with an extra column, the data in a new table will be same as old with a new coulmn which will be a calcualted value. for example consider salary for working hours. one column already has data about the working hours, how can i calculate the pay per hour in the next column to it.
it is simple, just create a new Dimension or an Expression as a new field.. check out the above example, it is well explained. what all you Need is to add a new calculated Dimension or create a new Expression.
