Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am in the process of trying to figure out how to format my pivot table so that it looks similar to the excel table. Below is a screen shot of excel table.
I was wondering if it is possible to have an expression return two values in a pivot table? Basically like a statistics box that that has a field being Date and also the Outstanding (1 - 30 days) field.
Any ideas or help would be greatly appreciated!
Thanks,
Michele
Simply use two expressions and drag the expressions to the left to pivot them to vertical layout.
The alternative is an expression like: =sum(Value) & chr(10) & money(count(Value))