Forum Discussion

gaurav1991's avatar
gaurav1991
Regular Visitor
9 years ago

Need Help!

I have a query. Please help!   I have 2 columns (X and Y) with 10 rows each.   1. In X column top 4 rows are blank and rest 6 rows have values. "X" Column Values: [Blank, Blank, Blank, Blank,...
GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi gaurav1991

 

What I would do is in the Query Editor I would create a Conditional column (Is Blank X) (Is Blank Y) and if it has a value then make it 1 else make it zero for your X and Y columns.

 

Then I would create another Conditional Column based the two columns above. And simply add them together with the new conditional column of (XYZ) 

gaurav1991's avatar
gaurav1991
Regular Visitor
9 years ago

Hello Guavaq,

 

I can't hard code the columns as column X and Y are actually the month's name and that will varies as the new sales data will be uploaded.

 

Actual Case, Its quarterly sales data, Month's names are used in columns after pivoting the data. I just need a dynamic function in which I don't need to hardcode the column name as that would be changed in next quarter.

 

 

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi gaurav1991

     

    You could possibly do this with a function.


    Do you have some sample data or sample images to see what you are trying to achieve?