only min value in pivot

[beck_bakytbek]

Hi Folks,

i have a situation:

Year:

2016     300 €

2015     200 €

2014     100 €

How can i make visible on pivot-table this structure; i want to ignore the values 300€ and 200€ and show only 100 €

Year

2016  0 €

2015  0 €

2014 100 €

Thanks a lot

beck

[sunny_talwar]

You want to show min year value or min value? If the 100 was next to 2015 and 200 was next to 2014, would you have shown 100 for 2015 or 200 for 2014?

[beck_bakytbek]

200 for 2014

Thanks Sunny

[sunny_talwar]

May be like this:

Sum({<Year = {"$(=Min({1}Year))"}>}Value)

[beck_bakytbek]

Sunny Thanks a lot for your Feedback,

i have a question, can i use such expression with cumulated values?, and can i show show min of cumulated values

thanks a lot

beck

[sunny_talwar]

Can you share an example of what you mean?

[beck_bakytbek]

of course Sunny,

Thanks a lot

[sunny_talwar]

What is the expected output you are looking to get?

[beck_bakytbek]

i expect a min value on the base of cumulated value

[sunny_talwar]

I sort of understand, but what is this value in the attached qvf? What are you expecting to see in your chart? What Year and what value next to it?