i've got a question about this situation, i have 2 tables:
The 2 tables are linked via CustomerId, and i have to calculate a pivot table with 2 particular expressions:
The first one is simple, count the number of tickets per date, which is simple using TicketYear,Month and Week as dimension and counting the TicketId.
But in the second expression is required to calculate the number of customers which have been ACTIVATED during the period of "Ticket Creation" i'm looking at.
This means that if i'm looking at the number of tickets created on the 25th week of the year, i need to have on the second expression the number of customers activated on the same week, but the dimension i have to use are still the ones related to the ticket.
I can't split in 2 pivot tables using different dimension, cause it's required and needed to have all in the same pivot.
Does anyone ever experiences something to accomplish this without messing up the tables structure in the script?