Ashwini Sayani
Posts
-
Sort by Multiple Columns
Hi, I have a table that looks like this - I want to multiple sort this: Brand Item Description Sales Acqua Di Parma COLONIA ESSENZA EDC 100ML 100 Acqua Di Parma ZAFFERANO EDP100ML 200 ...
-
Multiple Dimensions - Calculation
Hi, what does the formula look like when I have two time dimensions on the columns? The user dimension below has only 2023, 2022 as members. The second dimension has Week 1, Week 2 etc. I want to ...
-
Visibility agent for multiple dimensions
Hi, There are two dimensions in the crosstab (country, item) and one measure, sales. I need to show the top 5 Airport Countries, with the top 10 Item Desc for each country. Is there a way of d...
-
Copy of existing Column (dimension)
Hi, How can I create a new calculated column that would create an exact copy of the values in the first or second or third column here which are dimensions? Is there a syntax you could help me wit...
-
Rearranging Columns
Hi, I am trying to re-arrange the columns in my crosstab, but I am only able to move the calculation columns around and not the first few columns which are dimensions. The highlighted columns are...
-
Color Agent - comparison to dimension
Hi, I am trying to color the measure value below for each week based on the previous week. If week 34 is higher/lower/neutral vs week 33 I need to color green/red/black respectively, and week 33 vs...