I have below excel file data. Data entered manually and has no source for this data.
User don't want to upload this file for small data.
I have metric like if Id=1, then amount, if Id=2, then revenue etc.
Also using column B values as prompt values in dashboard to filter the data. This is the requirement.
Any way to created these columns in Incorta using Session variable or presentation variable? or any other way to create?
That said, I genuinely cannot think of a legitimate argument against uploading an Excel or CSV with those values.
Is the objection as simple as they don't want to do the upload? If so, can you do it yourself?
In any case, the linked solution will work for you.