Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
i have a pivot table and in it's Dimensions i have used a class function for classification as follow:
class ( myDate , varPeriod , 'Date' , -1 )
myDate is a "Date" type. In labels of each class shown in pivot table i have something like this :
40915 <= Date < 40919 40919 <= Date < 40923 ...
i need to customize labels. for example something like :
07.01.2012 11.01.2012
i need to mention that ( 07.01.2012 ~ 40915 ) and ( 11.01.2012 ~ 40919 ).
at least i need one of the following forms:
07.01.2012 <= Date 11.01.2012 <= Date
or
07.01.2012 <= Date < 11.01.2012 11.01.2012 <= Date < 15.01.2012
how can i do that?
thank you so much.
Hi Peyman,
use this :
=Date(subfield(text(class(myDate,$(varPeriod),' ')),'<=',1),'DD-MM-YYYY') & ' To ' &
date(subfield(text(class(myDate,$(varPeriod),' ')),' < ',2),'DD-MM-YYYY')
Regards,
Nilesh Gangurde
Hi Nilsen,
Thank you for answer.
but where i have to enter the expersion? the "Label for Column/Row" in peresentation tab of chart properties is disabled.
can you please explain where i need to write the expersion you offered?
try this
class ( myDate , $(varPeriod ), 'Date' , -1 )
hope this helps
thank you Sunil, but the second parameter is 'interval'. this doesn't help anymore.
we need to find a way to convert the displaying format of myDate that here is Integer not Date.
Hi Peyman,
On the Dimension tab u will see the "Add Calculated Dimension". Click on it and paste the above stuff there.
then add the expression For Example : sum(Sales ) in the expression tab.
Regards,
Nilesh Gangurde
Thanks againe Nilesh,
i did so. my expersion is like :
sum( {<A ={"1"}>} v1 - v2 )
but in pivot table i get the error message "Error in calculated dimension." and i loss the clasification.
aggr(sum( {<A ={"1"}>} v1 - v2 ),idfield)
hope this helps
what do you mean exactly Sunil?
aggregate expression by you key fields
so that it should show in your dimension
hope this helps