Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm struggling with the expressions on a pivot table,
My data is like this:
Product Price Date
A 26 5/5/15
A 27 23/7/15
B 32 23/7/15
And I want a pivot table that shows me the prices according to the date like this:
5/5/15 23/7/15
A 26 27
B - 32
Can anybody help me to figure out how the expression should be.. Does it have to be with the Aggr() function?
Thank youu
You can use multiple expressions.
e.g. if(max(Price)>'', max(Price), maxstring(Price) )
If your price data is correctly formatted, I would not expect text values only numeric values
Hi,
do you want like the below ?
find the attachment..
Hi,
Please have a look at the attached file, hope it helps!
Kiru
use 1st dimension as product
2nd as date.
expression as price.
you can even use only(price) as expression.
Thank youuu !!! The Only function was what I was looking for
It would be better to use avg(), min() or max() as the expression rather than only, as only() will return null if your product has different price values on the same date.
Yeah, that's what I noticed I wrote a numerical example in the question I asked, but in my actual app I have text values, so as you say, I have null values. Do you know any kind of solution for this situation?
You can use multiple expressions.
e.g. if(max(Price)>'', max(Price), maxstring(Price) )
If your price data is correctly formatted, I would not expect text values only numeric values