Forum Discussion
Pranav_R_
Aug 28, 2021Copper Contributor
How To Sort Excel Slicer By Number
Hi, I have multiple data in this order as you see below: Stories 1.1 Story 1.2 Story 2.1 Story 3.1 Story 3.2 Story 4.1 Story 4.2 Story 4.3 Story 4.4 Story 4.5 Story ...
Pranav_R_
Aug 28, 2021Copper Contributor
It is a PivotTable slicer. What is a helper column and how to add that?
Can you explain a little bit more about it. Please explain. Thanks
Can you explain a little bit more about it. Please explain. Thanks
SergeiBaklan
Aug 28, 2021Diamond Contributor
Sorry, formula for storyNumber column is
=LEFT( Table1[Stories], FIND(" ", Table1[Stories]) -1 ) + 0
didn't update screenshot in previous post.