Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to use sth like this in my dimenssion:
max(date)
how can i do it?
i have some table like below:
company | sales |
---|---|
a | 1 |
a | 2 |
b | 3 |
c | 4 |
d | 5 |
i want pevot like below:
company | Header 2 |
---|---|
a | 2 |
b | 3 |
d | 5 |
c | 4 |
i should use sale field in dimenssion
try below then
add in caluclated dimension tab
=Aggr(Max(sales), company)
wat abt c?
not clear what you want to achieve
why is a 2 and not 3 (the sum)?
why is c missing?
Please elaborate
Can you provide a sample that replicates your scenario, you've said you want to have "Sale" in dimension but your output table doesn't show how?
Can you create a sample in Excel with data and desired output
may b this?
because the maximum number af a is 2 and want to show the maximum number of each company in my pivot
i have to use it in dimensio i cant use this in dim
sorry i edited it
Max(sales) then as expression in the pivot table?
i need to use it in dimensio not in expression