About kjochim

The Add-On for Google Sheets will not open and allow us to connect from large workbooks. It only seems to work with smaller/single sheets. Has anyone else experienced this? Is this a limitation of the add-on? ... View more

I have a worksheet with presumably editable cells (displaying purple text). I can edit these fields in the module itself, however I can only edit some of them in the New UX Worksheet. Others, still with purple text, won't allow me to make changes. If these same fields are blank, I can type in data. I cannot write new data over the old. I have these set as text fields. All my list fields seem to be fully editable, but not these text ones. What am I missing?!?! ... View more

你好,我有一个模块和两个维度(除了time): customer (BA) and sales location (plant). I'm looking to use the RANK function to display the top twenty customers for a specific line item of value (net negative suspense). I want to display the top twenty customers having negative values on a dash, but I'd like it to be dynamic - switching between total company and specific locations. So it will display the top twenty regardless of location as the default but will switch to show the top twenty by location as each of the locations are clicked in other dashboard elements. The only way I could get the RANK function to work at the total company level was to remove the sales location dimension, but then the function is no longer dynamic. How can I rank the customers so that only the top twenty display on a dash but those twenty will dynamically switch based on the sales location (plant) selected? Help please ... View more