Hi,
I have a pivot table where I have fields loaded from other app and just call thats fields in my second app. But in the others columns I have formulas that brings last month. The formulas are right, But I have one field that shows Character So.
Column A (only the field) Column B
Character1 -
Character2 -
So on
In coIumn B I have to bring Character1 Character2 (Comparison columns) but with the last month and same day, Example if in Column A Brings 13-08-2014 in column B Should brings 13-07-2014.
My formula is
=Sum({<fecha={'>=$(=Date(Max(fecha) - 31))<=$(=Date(Max(fecha) - 31))'}>} Inv)/2
Where Inv is numeric This bring me Same day last month
=Sum({<fecha={'>=$(=Date(Max(fecha) - 31))<=$(=Date(Max(fecha) - 31))'}>} Per)/2
Where Per is a character so, Column B brings null values.
How can I show character in set analisys?
Thanks!
