Forum Discussion

Kannan4444's avatar
Kannan4444
Icon for Helper I rankHelper I
4 years ago
Solved

PY vs CY

is it possible to have the montha and year in the same format as the picture? Please share your ideas

  • Hi. Sure you can. Just create a hierarchy with date calendar table -> Year/Month and if it doesn't work add month name like Year/Month/MonthName (don't worry for the last item, you won't use it because you won't explore that level). Check the gif out

    concatenate labels

    I hope that helps,

1 Reply

  • Hi. Sure you can. Just create a hierarchy with date calendar table -> Year/Month and if it doesn't work add month name like Year/Month/MonthName (don't worry for the last item, you won't use it because you won't explore that level). Check the gif out

    concatenate labels

    I hope that helps,