I’m trying to create a template where people can introduce cost by supplier.
How can I insert new lines for a preset table or metric?
I tried to do so in the spreadsheet functionality bet it’s greyed out.
Thanks in advance,
G
I’m trying to create a template where people can introduce cost by supplier.
How can I insert new lines for a preset table or metric?
I tried to do so in the spreadsheet functionality bet it’s greyed out.
Thanks in advance,
G
Hi Guillermo,
Typically, to add a new line in your metric, you have to either create a new item in one of your dimensions, or change the filtering rules to display a new item. For that, an input dimension (e.g. with just numbered items - 1, 2, 3, etc.) can be used.
There are lots of ways to do this, all dependent on how you’ve already set it up.
Could you share more of the context in your table?
Curious to see if other modelers have smart ways of solving this.
Hi Guillermo,
I am totally agree with
If it is filtered by Hide empty row and column than you would not be able to see that supplier Row or Column. Please check the screensot below.
If you would like to able see supplier name which do not have data than you will have to select show empty row and column in filter. Please check the screensot below.
I think, it will resolve your issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.