show last letters in barchart xaxes

[mshailaja]

Hi all,

i have to show last leeters in xases of barchart suppose in the  bar chart x axes i have  sum(sales) for the product kalanjalikurthalehenga, i need  in x axs letters as lehenga only, How?

[MindaugasBacius]

Add calculated dimension.

Use Expression like Right(ProductName, 2)

[snehamahaveer]

HI Sailaja,

As Mindaugas mentioned earlier you can use a Right or Mid statement in your calculated dimension for product. However ensure your no of alphabets are consistent across all products.

[#4]

HI,

If your data as you say is kalanjalikurthalehenga then you need to cleanse the data and bring to a form from the back-end (Script Level).

And as suggested above i recommend that you transform the "Right(ProductName, 2)" in the script level.

I think you need to have delimiters eg:kalanjali-kurtha-lehenga

hope you get the jist.

[yoganantha321]

hi,

try with this

=Mid(Fieldname, Len(Fieldname)-2)

[Anil_Babu_Samineni]

Seems typo error Right(ProductName, 7)