How to club Dimension and get the out put results

[#1]

Hello experts,

I am working on some data where count of actions mentioned with their respective outcome. And I want to present 5 times action and incase if comeone has mor ethan that it should come along with 5th column as 5+

Look at this example.

Days	Production	Sale
1	927	836
2	506	706
3	937	712
4	872	839
5	729	776
6	881	868
7	750	717
8	880	725
9	557	991
10	525	797
11	559	614
12	1000	771

If in the above table i would like to show days as 1,2,3 & 4 individually and rest as 5+

then how should i present them in chart

Kindly help

Regards

[Gysbert_Wassenaar]

Use a calculated dimension as chart dimension: =if(Days<5,Days, '5+')

[miguelbraga]

Find the attached file:

[miguelbraga]

A snapshot of my solution:

[#5]

what about if i want the latest data of last 5 months not later than that

[miguelbraga]

Like this?

[miguelbraga]

Or this?

[#8]

Its correct yes this is how i want

If i am not wrong.

in this data if further more days will be added like 13 to 16

then i will get data from 12 13 14 15 16

If correct then let me know how to do it.

[sasikanth]

M

May be Like this , PFA

[miguelbraga]

Is this what you're looking for?