Currency selector (based on variable) usage in comparsion
Hi,
I've developed a currency selector based on the following topic, and it's working well in pivot tables and charts:
I also have a comparison pivot where I compare key metrics (e.g., revenue, cost, clicks, etc.) across a specific dimension (e.g., product). Each row represents one product, showing its current month's metrics and the percentage differences compared to the previous month. We just keep only the previous months records thats why I use query.
This comparison table is based on a query table. When I tried to switch the standard metrics to the currency-selector-based metrics, I realized that query tables do not support variables.
Is there any other way to compare current metrics with previous ones using an aggregate formula, while keeping only the current month’s records in the query table? (I found that I can compare within the query table, but the previous month’s value must also be displayed.)
Regards,
Szabolcs