Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have one filed called "monthyear" . in my pivot table monthyear is the dimension. there it shows 42370,42430..like that instead jan ,fed,...dec
How i can change the those numerical values into text?
if i writhe month(42370) then it will give the jan.. but here i want dynamically?
pl help me on this
Thanks in advance
Try with
month(Date(42370)) -->It will give you jan.
In script level..
month(Date(Filed name)) as Month
So here
month(Date(monthyear)) as Month.
May be just -
Month(monthyear) ?
Simply use
=Date(monthyear)
or if you display month then
=Month(monthyear)
i did not understood what do you mean by dynamically?
Hi,
Use
=Month(42370)
it will be return "Jan"