Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

[wiz_nerd]

fieldA	Fieldx	FieldB
stringa	1	1
stringb	2	3
stringc	3	8
stringd	4	7
stringe	5	1
stringf	6	5
stringg	7	6
	8	3
stringh	9	2
stringi	10	5

*********fieldA is string field and is not sortable and there is another field(FieldX) which is integer based on which I am sorting (fieldA)

I am creating a  bar chart but I want to consider N-1 values like i want to remove the last value here.

Stringi and only create the bar based on the rest of the values.

[sunny_talwar]

last value based on what kind of sorting?

[wiz_nerd]

*********fieldA is string field and is not sortable and there is another field(FieldX) which is integer based on which I am sorting (fieldA)

I have updated the question please check. Added one more field.

[sunny_talwar]

May be just exclude the max(fieldX) from set analysis

{<fieldX = {"<$(=Max(fieldX))"}>}

[wiz_nerd]

could you please share the exact dimension expression or QVW because I have checked this is giving me error.

[sunny_talwar]

Dimension

fieldA

Expression

Sum({<Fieldx = {"<$(=Max(Fieldx))"}>} FieldB)

[wiz_nerd]

Is there a way to create the calculated dimension  based on Field x and fieldA  to remove the last FieldA because I don,t want to touch the measure expressions??

[sunny_talwar · Accepted solution]

This

=If(Fieldx < Max(TOTAL Fieldx), fieldA)

[wiz_nerd]

This solution looks perfect to the problem statement may you also tell me how to remove the total values in the end of the chart.

[sunny_talwar]

Total value?