Ashwini Sayani
Activity overview
Latest activity by Ashwini Sayani-
Ashwini Sayani commented, Thank you Ole! Much appreciated!
-
Ashwini Sayani created a post, 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 ...
-
Ashwini Sayani created a post, 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 ...
-
Ashwini Sayani commented, Hi, improving on this example - how do I calculate the difference between prev month this year and prev month last year please?
-
Ashwini Sayani commented, Rank for top list with multiple dimensions – TARGIT Community - I found this helpful, but how do I only display top 3 in the first dimension with top 5 in the second dimension, what would be the vi...
-
Ashwini Sayani commented, Hi, thank you this is very helpful! Can I ask what is the visibility agent formula to show ONLY top 3 Customers with their top 5 salespersons please?
-
Ashwini Sayani created a post, 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...
-
Ashwini Sayani commented, Yes, but I am only able to rearrange the dimensions that way (highlighted columns). I want to bring in the calculated columns at the end in between the first few columns. For example, I want 'Cust...
-
Ashwini Sayani created a post, 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...
-
Ashwini Sayani created a post, 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...