🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

How should I configure the slice

Hannu Polso asked on March 29, 2018

I have set of data from years 2017 and 2018. There are numbers from every month from years 2017 and 2018. I want to show columns in order 1/2017|1/2018|2/2017|2/2018…12/2017|12/2018. How should I accomplish this? I attached report_current.json. It shows the current situation. Then there is report_requirement.json which shows my goal. I would like accomplish the goal without making “stupid” date formatting 🙂
I’m not sure if I’m able to state my question correctly. Feel free to ask if you need more details. Thanks 🙂

5 answers

Iryna Kulchytska Iryna Kulchytska Flexmonster March 29, 2018

Hello Hannu,
Thank you for posting your question.
Could you please re-attach report_current.json file you are mentioning above? 
Thank you,

Hannu Polso April 3, 2018

Here is the current situation again.
Best regards,

Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 3, 2018

Hello Hannu,
Could you please send us your report_current.json by e-mail?
Waiting for the update from you.

Tanya Gryshko Tanya Gryshko Flexmonster April 4, 2018

Hello, Hannu,
If your set of data contains only numbers from every month from years 2017 and 2018, the most convenient approach is to specify custom sorting. Please refer to our tutorial with explanations and examples: https://www.flexmonster.com/doc/custom-sorting/
Please let me know what you think about such option.

Hannu Polso April 26, 2018

Hello again,
and sorry for delay 🙂 Custom sort works.
This question may be marked as resolved 🙂
thank you

Please login or Register to Submit Answer